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