Add a Mysql as a Linked Server

The other day I got a request to migrate some data from Mssql to Mysql.  I am like ok fine, I will just use SSIS and it will take me a second.

This second led to more than four hours of frustrations.  Why?  Apparently Microsoft decided not to put any ODBC destination connectors on

the SQL Server Intelligence Studio (SSIS – 2005 version).

Note that my evironment consists of  the sql server 2005, bids (2005) .

FYI: It seems that on the 2008 version, Microsoft gives us the ODBC provider back.

If you are still running the 2005 version here are the solutions:

Setup SQL Server Linked Server to MySQL

Adding Mysql as a linked server

Insert into a MYSQL linked Server