3/29/2024 0 Comments Informix odbc portError code: 0x8004D01B.Įrror: 0xC020801C in Load CTLANCTO On Stage, OLE DB Source : SIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The connection between the development machine and Informix is through an ODBC connection, which is also successful in querying the tables.īut when the job is started the following error occurs in SSIS: Error: 0xC001402C in 1-Load CTLANCTO: SSIS Runtime Failed to Enroll OLE DB Connection in a Distributed Transaction with Error 0x8004D01B "The transaction manager is not available."Įrror: 0xC0202009 in 1-Load CTLANCT: SSIS Error Code DTS_E_OLEDBERROR. I also ran the cdotnet.sql and coledbp.sql scripts as directed by an IBM article to configure linked servers in SQL Server - and it worked. The Informix server is on a Linux Red Hat 6.5, where the SELinux is permissive, the IpTables disabled. All of the MSDTC settings of the target machine and the SQL Server database are working, and the RPC service is listening on port 135, both firewall are disabled and no antivirus is installed. I need to create an extraction job from an Informix database, the requirement is that I need to enable transactions in SSIS.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |