SQL Server 2005到MySQL的连接

I want to be able to email a report daily from a glpi database in MySQL. I would like to create a SSIS job to pull data from MySQL. How do I do this?

我希望能够每天从MySQL的glpi数据库发送报告。我想创建一个SSIS作业来从MySQL中提取数据。我该怎么做呢?

2 个解决方案

#1

I would suggest using ODBC or the MySQL .NET adapter. SSIS can easily use these connections

我建议使用ODBC或MySQL .NET适配器。 SSIS可以轻松使用这些连接

#2

Create a Linked Server to mySQL from SQL Server 2005.

从SQL Server 2005创建到mySQL的链接服务器。