October 16, 2008 at 1:45 am
Hi All,
I have a Sequence container with a number of DataFlows. On my Connection I have RetainSameConnection set to true.
Going into my Sequence I have an SQL Task that calls 'Begin Transaction' and after my sequence containier I have another SQL Task with 'Commit Transaction'.
All Packages within the Sequence container have FailPackageOnFailure and FailParentOnFailure set True. The Sequence itself also have these set to true.
The first package in the sequence does a table copy of some fields from one table to another. The second package also inserts some records into another table based on a Stored Proc. These all work fine, I'm trying to prove that the transaction works and want everything to rollback on a single failure anywhere in the sequence. For now, I've forced the third Data flow to fail and indeed it does. It seems to rollback the transaction performed by the second Data Flow, but the first data flow does not get rolled back. Has anybody any thoughts on this. thanks.
October 16, 2008 at 4:37 am
Ok Folks, I managed to get to the bottom of the problem. I needed to remove the SQLScripts that did the transaction. At Package level Set the Transaction Option to Required and the Connections RetainSameConnection to False.
This solved my problem. If you have a similar and it still fails check the the DTC is running on the machine that the package is runnign on otherwise it will fail.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply