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?
The precedence constraint statuses are Success, Fail and Complete. Complete is whether it Succeeds or Fails.