HI

I've got an SSIS package which contains an Execute SQL Task.

When the SQL task (a stored procedure) throws an error and the package fails.

But I want to handle the error so I've got a constraint on failure to take a different route through the package and the step is set to not fail the package..

But this is not being followed.

Any ideas what I might have missed.

Thnaks

Nick