Hi,

I have several Transform Data Tasks in a DTS package, and I would like to
email a user if any of these tasks fail. In particular I would like to add
a description of the error.

I have looked at using a Send Mail Task, but can't figure out to harvest
any error details.

Very grateful for any help and advice.

Regards,
Martin

--
Message posted via http://www.sqlmonster.com