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?