DTS Failure notification | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Failure notification

Hi,
Is there a way where the DTS packages mails automatically when it fails.
I know the way where we use in DTS designer execute package and then on
failure use excute SQL task(within that xp_cdosysmail). Any easy way
other than that.
Thanks in advance
Rajesh
If the DTS is scheduled from SQLAgent, you can use SQLAgentMail.
When the DTS fails, the job can be configured to notify an operator via email, NET SEND, or pager
]]>