Transactions

From: Hari (Hari_at_discussions.microsoft.com)
Date: 07/01/04 

Date: Thu, 1 Jul 2004 07:36:01 -0700

Hi i am new to DTS and i want to try one thing. please help me out with this.

i have three packages and i am creating one more package which uses three execute package task to run each of them. and Lets say that i am running them serially, i.e. 1st and then 2nd and the third. But during that if any one of this package has an error and it fails all the three package should roll back, i.e. if first one fails then no prob(because i have precedence constraints). But if third one fails after sucessful completion of first two, then all the three should roll back.
Can somebosy help me with this.