x

[Closed] SSIS failure with Distributed Transaction error

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.

more ▼

asked May 31, 2016 at 09:10 AM in Default

avatar image

nidheesh.r.pillai
9.5k 22 59 49

(comments are locked)
10|1200 characters needed characters left

The question has been closed Jul 29, 2016 at 01:14 PM by nidheesh.r.pillai for the following reason:

The question is answered, right answer was accepted


1 answer: sort voted first

The problem was fixed when the DNS configurations for the local server where the package is located; and the hosting server to which the connection was being made were reconfigured.

more ▼

answered Jun 01, 2016 at 07:24 AM

avatar image

nidheesh.r.pillai
9.5k 22 59 49

(comments are locked)
10|1200 characters needed characters left

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x23
x2

asked: May 31, 2016 at 09:10 AM

Seen: 427 times

Last Updated: Jun 01, 2016 at 07:24 AM

Copyright 2017 Redgate Software. Privacy Policy