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 http://www.mysql.com/downloads/connector/net/ (http://www.mysql.com/downloads/connector/net/)
Connector/Net is a fully-managed ADO.NET driver for MySQL.
MySQL Connector/ODBC 5.1 (Which is already installed, in our previous article)[Read more...]