sql server dts: ForEach continue on Failure -- sql server dts

ForEach continue on Failure

Larry Charlton
7/21/2006 2:30:02 AM

sql server dts:

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,

RE: ForEach continue on Failure

Todd C
11/22/2006 7:36:02 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.