>>
>>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 :-(