rsmuckles
asked on
Errors when pulling data from MS Access into Sql Server 2005 database using Visual Studio
I'm working on a 64 bit server and have tried setting up a package to pull in data from an access database into sql server 2005. I set up my source connection as oledb and the access database file name and path is in the database file name box. When I test the source connection it works perfectly. Same with the destination. The data flow task has the source and the destination - I can see the columns and the mapping works fine. When I execute the task the package fails with the following error at the source.
Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECT IONFROMCON NECTIONMAN AGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Any ideas? Thanks as always for your help.
Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECT
Any ideas? Thanks as always for your help.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
And here is a great comment from Brian Nights blog (MVP) - see some of the comments that follow as well...
your package is not making the connection to the source... do you have ODBC connections?
Try to execute the SSIS package as 32 bits... and check if the error still ocurr...
Regards!!