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