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
Prerequisite:
___________________________________________________
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/
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]