Error - established under a different transaction? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Error - established under a different transaction?

Author

Topic

ostinoh
Yak Posting Veteran

66 Posts

Posted - 2011-12-21 : 15:26:20

Hi -

My SSIS Package is setup to have the Transaction at the package level

IsolationLevel = Serializable and TransactionOption = Required

When I try and run my package the first part runs

Progress: Executing query "DELETE FROM TIMEDATAFETCH  WHERE [TIME CARD PERIOD". - 100 percent complete

And then goes right to red and the package fails. Below is the log with the errors in it.

SSIS package "TDF_Pull_Package.dtsx" starting.
Information: 0x4004300A at Refill Table, DTS.Pipeline: Validation phase is beginning.
Information: 0x4001100A at TDF_Pull_Package: Starting distributed transaction for this container.
Information: 0x4004300A at Refill Table, DTS.Pipeline: Validation phase is beginning.
Error: 0xC001A004 at TDF_Pull_Package, Connection manager "DestinationConnectionOLEDB": Incompatible transaction context was specified for a retained connection. This connection has been established under a different transaction context. Retained connections can be used under exactly one transaction context.
Error: 0xC020801C at Refill Table, Destination - TimeDataFetch [133]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER.  The AcquireConnection method call to the connection manager "DestinationConnectionOLEDB" failed with error code 0xC001A004.  There may be error messages posted before this with more information on why the AcquireConnection method call failed.
Error: 0xC0047017 at Refill Table, DTS.Pipeline: component "Destination - TimeDataFetch" (133) failed validation and returned error code 0xC020801C.
Error: 0xC004700C at Refill Table, DTS.Pipeline: One or more component failed validation.
Error: 0xC0024107 at Refill Table: There were errors during task validation.
Information: 0x4001100C at Refill Table: Aborting the current distributed transaction.
Information: 0x4001100C at TDF_Pull_Package: Aborting the current distributed transaction.
SSIS package "TDF_Pull_Package.dtsx" finished: Failure.
The program '[10456] TDF_Pull_Package.dtsx: DTS' has exited with code 0 (0x0).

Can someone help me understand what this means and how to fix it?

Regards,
D-

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-22 : 02:00:55

what have you set as value for Retainsameconnection property of connection object?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

ostinoh
Yak Posting Veteran

66 Posts

Posted - 2011-12-22 : 08:12:42

It is set to "True"

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-12-22 : 10:55:16

did you try with that setting as false?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources