I've got a package that uses some Execute SQL tasks to mark staging records
and either insert or update them into production tables, based on how
they're marked. Initially, there were problems with my marking queries, and
I ended up trying to insert records that already existed. This should have
caused the task to fail, and then fire my ActiveX task to notify me that it
failed, subsequently failing the package.

What's happening is that the failing task just ends, no On Failure tasks
execute, no tasks any further down the workflow execute, and the package
returns successfully. If these Execute SQL tasks fail for any reason, I've
got be notified and the package has to fail.

Help!

Tom Bunton

Nevermind, I figured it out...

"msnews.microsoft.com" <trbunton (AT) hotmail (DOT) com> wrote