>>>>
>>>>This is occurring in a Foreach loop container.
>>>>
>>>>I juts tried a test in a small dtsx of a simple sql statement that fails and the right route is taken.
>>>>But when that is in the foreach it fails the package even though FailPackageOnFailure is F.
>>>>
>>>>Nick
>>>
>>>OK....what kind of foreach loop? (..for each file, for each ADO record, etc.....)
>>
>>A file foreach
>>
>>But I found a tip to set maximumerror count to 0 and then my test works but unfortunately the actual package I'm working on still doesn't :-(
>
>Is your error routine/error path "inside" the foreach loop or outside?

There is an error event handler for the package but not for the the sql step . Its an SSIS template somewhat larger than I'm used to used by the people I'm working with at the moment.

SO the SQL step that I've added is in a for each loop which is in a container which is in a container .

I've just tried adding passing out a parameter from the step and a conditional contraint based on that but that gets ignored as well. And I've temporarily deleted the package error event handler as well.

And still no go.

Maybe I should handle any error in the sql so it never fails and pass out my own error result.