May 9, 2002 at 11:21 am
I have a parent package which calls 5 other children packages. which is the best way to make sure that a commit happens only when the 5th child package executes successfully. ie if any of the other packages fail then the parent package should fail and there should be a full roll.
May 9, 2002 at 2:18 pm
I do believe that each triggers a commit and you cannot rollback. Might try pushing data to a import table if is an import and then handle the move of the data from that table to the main tables this way you can control a failure and handle rolling back and truncating the import table.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 16, 2002 at 1:11 pm
There is a property 'Join Transaction if present' for a task. look into using this. i do not have experience with it. But this might be what you need.
I have a parent package which calls 5 other children packages. which is the best way to make sure that a commit happens only when the 5th child package executes successfully. ie if any of the other packages fail then the parent package should fail and there should be a full roll.
[/quote]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply