In my previous article I had created linked server, to access and query a database. However, it is just the basic step to try and bring two different RDBMS systems linked together.
In this article I will discuss about creating a SSIS package to transfer data from MS SQL Server 2008 to MySQL 5.5
SQL Server Business Intelligence Development Studio
MySQL Connector Net 5.2.7
You can download this package from …[Read more...]