Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MySQL Database Source in SSIS Expand / Collapse
Author
Message
Posted Monday, March 22, 2010 3:30 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 2, 2014 11:14 AM
Points: 103, Visits: 450
How do I connect to MySQL Database in SSIS
please advise ..if there is a plugin for that ???
Post #887231
Posted Monday, March 22, 2010 5:53 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 2, 2014 11:14 AM
Points: 103, Visits: 450
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 !
Post #887293
Posted Tuesday, March 23, 2010 8:56 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, November 8, 2012 3:45 PM
Points: 22, Visits: 185
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.
Post #888189
Posted Tuesday, March 23, 2010 9:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, June 2, 2014 11:14 AM
Points: 103, Visits: 450
Yes thanks it worked..

but now I have a separate issue I will open a new post

thanks
Post #888202
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse