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
 General SQL Server Forums
 New to SQL Server Programming
 DTS And Email

Author  Topic 

Faris2100
Starting Member

10 Posts

Posted - 2007-04-10 : 22:22:32
Hi all,

I am using SQL 2000 and i have DTS packages that are used to trasfer data from a datasource to SQL server. i want to set up the packges so i get an email for every step that failes, so i use on failure send email for each step. the question is what do i use to send the email, i know DTS has a MailTask but is this the only option and how is that different from XP_sendmail??

Appreciate any help
thanks
   

- Advertisement -