IBM Support

Using SSIS (SQL Server Integration Services) with a properly configured Informix OLEDB driver may yield SSIS Error Code 0xC0202009

Troubleshooting


Problem

SQL Server Integration Services (SSIS) is used with Informix databases and Informix CSDK for things such as data extraction and data loading. After initial installation of oledb on a Windows environment, the oledb layer works with SSIS to pass data between SQLServer and the Informix database. During the initial setup, configuration issues may prevent connectivity.

Symptom

When the user tries an Informix connection using the OLEDB data source, an error similar to the following may be encountered:


[OLE DB Source [1]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "database@servername" failed with error code 0xC0202009.

[{"Product":{"code":"SSVT2J","label":"Informix Tools"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Informix Client Software Development Kit (CSDK)","Platform":[{"code":"PF033","label":"Windows"}],"Version":"3.5;3.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
03 June 2021

UID

swg21611649

Page Feedback