DTS Error 1

[therealbirdman]

I have a DTS package which stops execution and rolls back if it encounters any errors. However, I want to send an email from the package when any one of the multiple tasks in the pkg fail. Currently, I have the "Send Mail Task" object set to one task which will be triggered if there are any errors on this task only. I do not want all the tasks to have the "Send Mail Task" object linked.

If anyone has tips please let me know.

Thanks

HB

 

[Bond7]

Hi,

Create another package which call this package and add send mail task to this new package on it's failure.