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.
| Author |
Topic |
|
LearningSQLKid
Yak Posting Veteran
51 Posts |
 Posted - 2014-11-17 : 06:32:51
|
Hi I have a question
I have three sequence containers. Each sequence container has its own dataflow task. if my first container fails i want the rest to stop immediately. Is it possible in ssis ?
Select Knowledge from LearningProcess |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2014-11-18 : 09:23:51
|
To roll back if failure in container:
Set Transaction Option to Required on container
Set Transaction Option to Supported on tasks within container
Set FailPackageOnFailure to True on container
We are the creators of our own reality! |
 |
|
|
Andre1802
Starting Member
4 Posts |
Posted - 2014-11-20 : 05:52:47
|
| Are they running simultaneously or after each other? |
|
|
|
LearningSQLKid
Yak Posting Veteran
51 Posts |
Posted - 2014-11-21 : 08:09:14
|
quote:
Originally posted by Andre1802
Are they running simultaneously or after each other?
simultaneously
Select Knowledge from LearningProcess |
|
|
|
|
|
|
FAIL ALL SEQUENCE CONTAINER IF ONE FAILS