question

My SSIS package is failing with a Distributed Transaction error as below Error: 2016-05-24 04:45:14.74 Code: 0xC001402C Source: Package Connection manager "DBConn" Description: 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". End Error Error: 2016-05-24 04:45:14.74 Code: 0xC0202009 Source: Package Connection manager "DBConn" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x8004D00E. COM error object information is available. Source: "Package" error code: 0x8004D00E Description: "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". ". End Error **What I have tried so far-** a. I checked the localDTC properties for the local server where the package is located; and the hosting server – (This is where the connection for DBConn is getting pointed to) and found them to be OK. b. I also checked the firewall rules to see if inbound and outbound traffic allows DTC rule and found them to be OK. Please assist.