• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SqlServer2000 DTS package

 
Rajan Chinna
Ranch Hand
Posts: 320
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
After completing a task(DML SQL scripts) I want to send out email notification about job status within DTS.

Is there anyway to capture the error message of failed task, and include it in the email?
Thanks.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic