I have a ForEach Loop. In the ForEach Loop there is a Sequence Container
that has a couple of ExecuteSQL tasks. If those tasks fail I want to do some
additional logic and in either case loop again.

Everything works fine as long as nothing in the SequenceContainer fails. If
it fails, it will continue through the additional logic, but the loop will
terminate at that point.

Is there a way to get the loop to keep looping even though one of the
internal steps failed?

Thanks,

Larry

It's been 4 months since you posted this but it might be usefull anyway:

Take a look at the properties of the tasks inside the containers. Look for
propertis named "FailParentOnFailure" and "FailPackageOnFailure".

These yes/no properties might help you configure your control flow. You
might also look at eh precedence lines between taks. Green is OnSuccess, but
you can also set it to OnFail or OnCompletion.

Hope this helps
--
Todd Chittenden


"Larry Charlton" wrote: