Using the IBM OLE DB Provider for DB2

  • 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.

  • You need to install the ODBC driver on the server.

  • 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