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.

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 FAIL ALL SEQUENCE CONTAINER IF ONE FAILS

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!
Go to Top of Page

Andre1802
Starting Member

4 Posts

Posted - 2014-11-20 : 05:52:47
Are they running simultaneously or after each other?
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -