October 23, 2009 at 2:17 pm
I have a DTSX package that import from a SQL 2005 to SQL 2005 db.
I just found out that one of the 2005 servers is going away and a MySQL db will be stood up in its place tonight.
I got the ODBC dll from the MySQL Website, but when I go into my dtsx package I do not see it as a connection in the OLE DB connections.
However I can see it in the OLE DB connections under MS ODBC Admin.
Anybody know how I can get this to work in my DTSX package?
Thanks!
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
October 23, 2009 at 7:38 pm
I figured out how to conenct using an ODBC connection, but now I cannot figure out how to get a datasource to use that odbc connection.
Has anyone ever added a MySQL DB as a linked server?
Twitter: @SQLBalls
Blog: http://www.SQLBalls.com
Channel: https://www.youtube.com/@Tales-from-the-Field
October 23, 2009 at 8:04 pm
There is a .NET provider so depending on the version you are using just download and install the provider in the link below.
http://dev.mysql.com/downloads/connector/net/6.1.html
Here is an article explaining known issues with the ODBC connection.
http://www.packtpub.com/article/mysql-data-transfer-using-sql-server-integration-services-ssis
Kind regards,
Gift Peddie
October 25, 2009 at 10:16 am
Hi.
This might be helpful:
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply