July 27, 2007 at 10:25 am
I have an SSIS package that is designed to extract data from a DB2 database and write it to a flat file on the local server. While testing this package, I installed the DB2 ODBC driver onto my local desktop - it ran successfully. However, when I deployed and ran it on the server, I received the following error:
Error: The AcquireConnection method call to the connection manager "<name>" failed with error code 0xC0202009.
I guess the obvious question is does the ODBC driver need to be installed onto the server? Or could it be something else?
If someone has a solution to my problem, please share it with me.
Thanks.
July 27, 2007 at 11:49 am
You need to install the ODBC driver on the server.
July 27, 2007 at 11:54 am
Yeah, I kinda figured that.
Thanks, Lynn.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply