November 7th, 2006, 02:24 PM
|
|
Registered User
|
|
Join Date: Oct 2006
Posts: 17
Time spent in forums: 57 m 17 sec
Reputation Power: 0
|
|
SSIS Package Transaction Integrity
1) I created many data flow task packages.
2) Then a execute package task in which I ordered relationally execute above data flow packages.
3) What I find is when a package fails, it is rolled back, execution stops but not the packages before this failed one.
4) What to do to rollback all in case of error and commit only if all are successfully executed?
|
Dev Articles Community Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
