DTS error capturing

Is it possible to capture the error message when a scheduled DTS package fails and to send it in a mail?Can't you code the On Success or On Failure workflow steps?|||but that will just tell me whether the step failed or executed successfully, what If I want to capture the error message and send it thru email, in case it failed?
is it possible to store the error message in some global variable and then read the content in the send mail step?|||If you're talking about a EXECUTE SQL Task (which you can just about do anything with)...you can trap errors as you would normally do...

If you're talking about transformations...I don't know..sorry, don't use DTS too much (well, not at all)

What are you trying to do?|||Originally posted by rohitkumar
Is it possible to capture the error message when a scheduled DTS package fails and to send it in a mail?

Hi rohitkumar,

Did you find the solution? I would like to do the same.

Thanks
Stephanie|||You should be able to set up logging for the particular task, and also select to log the particular rows that cause a problem. Then (with a bit of work), you should be able to set up an "on failure" task to e-mail you the log file if there is an error.

Regards,

hmscott|||Originally posted by hmscott
You should be able to set up logging for the particular task, and also select to log the particular rows that cause a problem. Then (with a bit of work), you should be able to set up an "on failure" task to e-mail you the log file if there is an error.

Regards,

hmscott

Hi,

Are you talking about the logging options of a package?

Thanks
Stephanie|||but checking the logging option on different tasks makes the package run very slow.

-rohit|||The following link has code to a sp that checks for package errors:

link (http://www.databasejournal.com/features/mssql/article.php/10894_1459181_2)