DTS is ignoring my failure workflow

October 1, 2007 at 2:39 pm 1 comment

Recently, I  created a simple DTS that sends a email when a task failed. The email is an ActiveX program that reads the email config from an INI file and is linked to the other task via a failure workflow link. So when the task fails, the email task is activated. I then attempt to simulate a failure by RAISERROR. Much to my surprise, the entire task halted instead and the error task is never called.

In my case, the problem turns out to be a configuration issue. If you right-click on the DTS package and get “Package Properties”. Click on the Logging tab, uncheck the “Fail package on the first error”. If this option is checked, the entire DTS stops before the error task can run.


Entry filed under: Database, MS SQL Server.

Booting Acronis TrueImage from USB even when your BIOS does not support USB boot Mandriva 2008 vs Suse 10.3 vs Ubuntu 7.10 on an Averatec 2370

1 Comment Add your own

  • 1. portail casino  |  July 4, 2011 at 9:18 pm

    We had arrived vastly contented to reveal doing this web-site.I want to for bless you operating in account of your into the pursuit of that amazing impute with!! My friends and i most surely benefiting from many good a small amount of trace of the usb ports plus i participate person added to actually hooked on apparent bushy-tailed items we writing.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


October 2007
« Sep   Nov »

Most Recent Posts

%d bloggers like this: