CODEWITHSUNDEEP
sql-serverssisssis-2008
Diomedes
Diomedes

Reputation: 658

Several Independent ForEach in SSIS Package

I need to have several ForEach in the same SSIS, which are not dependent on each other - if one fails, I want the other ones to run. Each ForEach will have others tasks on failure or success (send emails, etc). So I was thinking of putting each ForEach inside seperate Sequence Containers, so they run in a specific order as opposed of all at the same time. But I cannot tell the Sequence to run the next one on both success and fail.

Which would be the best approach in this case?

Upvotes: 1

Views: 36

Answers (1)

billinkc
billinkc

Reputation: 61201

The precedence constraint statuses are Success, Fail and Complete. Complete is whether it Succeeds or Fails.

Upvotes: 2

Related Questions