SSIS ODBC Source Previews Data But Fails When Executing Package

0

This is really odd to me. I am using an ODBC connection as a data source in SSIS. I am able to preview data, but when I attempt to execute the package (still within Visual Studio for development), I get an error on the initial data source.

The error I am receiving is:

There was an error trying to establish an Open Database Connectivity (ODBC) connection with the database server.

The AcquireConnection method call to the connection manager xxx failed with error code 0xC0014009.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.

ODBC Source failed validation and returned error code 0x80004005.

Clearly I have the right username, password, and ODBC connection to some degree, because I am able to see the data. However I am failing on establishing the connection when I attempt to run the package, so I must be doing something wrong. Any idea what it might be?

ssis
odbc
asked on Stack Overflow Apr 9, 2021 by Andrew

1 Answer

0

It ended up being that the drivers associated with the ODBC connection (gsk8ssl.dll) installed on the machine needed to be added to the path variables on both my local and on the server. This was for connecting to a DB2 database.

answered on Stack Overflow Apr 27, 2021 by Andrew

User contributions licensed under CC BY-SA 3.0