SQLTeam.com | Weblogs | Forums

Ado.net issue in ssis package

Hi i am loading the data from mysql database to sql server. I have added mysql odbc driver for 32 bit in system DSN in local and virual machine.I can run in dev server.But i am not able to run the package in prod. Getting error as ADO.NET Source has failed to acquire the connection.[ODBC Driver MANAGER] data source name not found and no default driver specified.
And i have enable the 64bitruntime to false and have choosen 32 bit while executing the package.

This helped me in the past

wrong site sorry. let me look at my implementation

I have solved this issue.

1 Like