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
http://www.ideaexcursion.com/2009/02/25/howto-setup-sql-server-linked-server-to-mysql/
Adding Mysql as a linked server
http://www.infi.nl/blog/view/id/4/How_To_MySQL_as_a_linked_server_in_MS_SQL_Server
Insert into a MYSQL linked Server
http://www.youdidwhatwithtsql.com/insert-data-mysql-tsql/4