I would like to set up a send mail task in DTS which will send out an email notification after certain step in the DTS has been processed successfully.

I am not using Microsoft Exchange Server and I don't have the Outlook client installed on the server. I would like to send the email out from an SMPT server. How do I set up the mail profile in the Send Mail Task configuration screen? If it is not possible, is that any way to send out an email notification from DTS.

I have seen in some messages mentioned about xp_sendmail. Any example on how does xp_sendmail work?

Thank you.

I Cheung

You might like to take a look at this most excellent tool

http://www.sqldev.net/xp/xpsmtp.htm

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"I Cheung" <anonymous (AT) discussions (DOT) microsoft.com> wrote

successfully.
SMPT server. How do I set up the mail profile in the Send Mail Task
configuration screen? If it is not possible, is that any way to send out an
email notification from DTS.

Thank you.

The xpsmpt seems to work but it does not support authentication. Our SMPT server needs to be authenticated. Is there any way to handle this?

----- Allan Mitchell wrote: -----

You might like to take a look at this most excellent tool

http://www.sqldev.net/xp/xpsmtp.htm

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"I Cheung" <anonymous (AT) discussions (DOT) microsoft.com> wrote

successfully.
SMPT server. How do I set up the mail profile in the Send Mail Task
configuration screen? If it is not possible, is that any way to send out an
email notification from DTS.