When running a SSIS package on a 64-bit computer, you may receive below error messages:
Error1: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D00E "The transaction has already been implicitly or explicitly committed or aborted".
Error2: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ora" failed with error code 0xC0202009.
Error3: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x800703E6.
An OLE DB record is available.
Solution:
Make sure you have enable MSDTC network access, and open the exception for DTC in Windows Firewall.
Error1: The SSIS Runtime has failed to enlist the OLE DB connection in a distributed transaction with error 0x8004D00E "The transaction has already been implicitly or explicitly committed or aborted".
Error2: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "ora" failed with error code 0xC0202009.
Error3: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x800703E6.
An OLE DB record is available.
Solution:
Make sure you have enable MSDTC network access, and open the exception for DTC in Windows Firewall.
; "Solar-Halo.jpg")
; "sweetpotato.jpg")
; "cardgame.jpg")
Leave a comment