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
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

Let's share thisShare on FacebookShare on Google+Tweet about this on TwitterShare on LinkedIn