Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Import/Export (DTS) and Replication (2000)  Modularization of Emails on Failure

Author  Topic  tech101 Starting Member 1 Post Posted - 2007-09-09 : 20:02:58 In a DTS package, it is a laborious task to connect an On Failure Workflow to a different Send Mail Task for each task (major or minor). I am trying to do some researching on a single effective way of sending an email with a description of the error and the job->task that it belonged to. What I thought could be possible is to have an On Failure Workflow coming from each of the tasks in a package pointing to an ActiveX script that can gather the Job (if applicable), DTS Package and Task name, error code, message and description, and the time of the error and put it into a temporary global variable, then use that to make up the subject and body in a Send Mail Task. Though I have never done anything like this in DTS before. The down point here is that there will be a very messy DTS diagram at the end with all the candy red arrows pointing to the ActiveX task. Slightly more agreeable than having a separate Send Mail task at the end of each red arrow. Is there a better way to do this?