What needs to be instlled on the SQL Server to enable a DTS package to use
SQL Mail? I gotta use an SMTP server on another box to send out SQL mail, so
it needs to be able to send the mail to an SMTP server. I understan that if
you have a mail client instlled on the server, that this will allow you to
mail out of SQL mail. Is this true? Any artcles on this out there?
--
Chris Davoli

Chris Davoli wrote:
SQL Mail requires a MAPI client, There are plenty of KB's about the
trials of SQL Mail, as well as some good setup articles.

This will allow you to use the xp_sendmail stored procedure for sending
mail for example. The DTS Mail task also uses MAPI, so setup and
requirements are much the same.

I'd recommended you look at an alternative that is simply sends direct
to a SMTP server and avoids MAPI, and the extra hassle and to be honest
extreme unreliability of using MAPI in an unattended environment. See
http://www.sqldev.net for a excellent extended procedure solution as
well as a a DTS mail task that uses SMTP directly.

--
Darren
http://www.sqldts.com
http://www.sqlis.com

we are having the same process. Creating an excel file via DTS and calls an
external program that sends out that excel file. you can find email
applications with keyword 'SMTP'. you shld have a valid smtp server though
to make this work.



"Chris Davoli" wrote: