SSIS Connection to MySQL when run in Jobagent

392 views Asked by At

I need to use SSIS to copy data from a external MySQL database to another external SQL database. When I run the pacakge in Visual stidio, everything works fine. But when I deploy to a local Integration services catalog (on local SQL server) and run the package through jobagent, I get the following error:

The AcquireConnection method call to the connectionmanager MySQLDB.com failed with error code 0xC0014009.

The validation of the ODBC connection to (MySQL) is failing. I am using MySQL ODBC 5.1 Driver. But as stated above, it works when running the same package in Visual studio...

I have plenty of packages running and working in jobagent but none is using a connection other then to SQL server.

What am I missing here with the MySQL Connection?

0

There are 0 answers