dts and sqlmail task

[swoodring]

In a DTS is there a way to set up a sqlmailtask that would send a mail message if any part of the dts package failed. I know I could set up one sql mail task for each step or task but was hoping there might be a way to specify if any step or task fails send a sql mail message.

Stacy

 

[DougP]

Have you looked at Error Handling in the T-SQL code.
I just looked briefly in SQL Books-On-Line that came with SQL Server.
RAISERROR is one and looks like it can send an Error message back to the client so it may be able to send an e-mail.


DougP, MCP
dposton@universal1.com

Ask me how Bar-codes can help you be more productive.