I tried to use SQL Mail function in the DTS. Is it
possible I can send E-Mail without using SQL Mail in SQL
Server . I knew that there is an CDOSYS.dll driver in the
server. How to use CDO to send E-Mail? Many Thanks.

Here is an alternative that a lot of people are getting happy about

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

--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Leo" <leo16882001 (AT) yahoo (DOT) ca> wrote

I implemented a solution somewhat differently. I have a DTS package that
creates an XMLRPC post
and sends it to a special mailer ASP Script on one of our Win200 Webservers-
the webserver sends
the email via CDONTS. Very round-about to be sure, however, we have a very
odd network
configuration here.

Andrew

"Leo" <leo16882001 (AT) yahoo (DOT) ca> wrote