March 22, 2010 at 3:30 am
How do I connect to MySQL Database in SSIS
please advise ..if there is a plugin for that ???
March 22, 2010 at 5:53 am
folks ! I found a .Net provider executable which I installed and created a provider to MySql database...but now when I create the connection manager I am getting errors as follows....
Error : " Test connection failed because of an error in intitializing the provider
unable to connect to the specified MySql hosts "
I added a connection by right clicking on database connnections in server explorer which worked fine and it even displays the tables, SP, of that perticular MySql database but when I create a connection manager and specify the same server name uid and password I get that error i mentioned...
please advise !
March 23, 2010 at 8:56 am
I use an ODBC driver, but this article seems like a good one for explaining how to connect to a MySQL db.
http://www.ideaexcursion.com/2009/06/04/howto-connect-to-mysql-in-ssis/
Post back to let us know if it worked for you.
March 23, 2010 at 9:05 am
Yes thanks it worked..
but now I have a separate issue I will open a new post
thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply