I have an SSIS package that uses a for each loop to send an order confirmation e-mail. If it does not find an email I need the package to continue after the failure path. The package stops after the failure, but I need it to continue with the next iteration of the for each loop. How can I do this?

Suppress execution errorpropagation up the container hierarchy, so that the foreach loop container is unaware of errors in its own executables. Specifically, set thePropagate system variableto falseon an event handler scoped below the foreach loop container.Propagate is a systemvariable which controls upward execution errorpropagation. See the following post for more details on how to set the value of this system variable. http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1561849&SiteID=1 Now, for validation errors, which will always bubble up at least one level up the container hierarchy, you'll have to set do somethinglike setting the MaximumErrorCount to a large number on the foreach loop container.

That works for me. Thanks.

This seems to be the standard way of handling this type of situation. However, regardless of the Propagate system variable, all errors will be bubbled up to a Parent Package. What's the recommended way of handling an error in a child package that is part of a loop of a parent package? The only way I've found is to not use parent/child packages :(