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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy