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.

Advertisements

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.

    Reply

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

Trackback this post  |  Subscribe to the comments via RSS Feed


Calendar

October 2007
M T W T F S S
« Sep   Nov »
1234567
891011121314
15161718192021
22232425262728
293031  

Most Recent Posts


%d bloggers like this: