Looking at your error message more closely it could be related to the DSN.
Consider where it is a 32 bit DSN or a 64 bit DSN.
http://sql-ution.com/32-bit-odbc-connections-with-64-bit-ssis
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/