I have to send an e-mail based on the results of a SELECT.
i.e.
SELECT something
FROM sometable
WHERE something

The e-mail must contain text based on this result.
How can I do it with DTS.

Thanks.

to run in DTS you need to create an Execute SQL task and use the xp_sendmail
Extended Stored Procedure (see Books online for more info)

http://msdn.microsoft.com/library/de...aa-sz_6hbg.asp

Andy.

"Vicente Fuentes" <vicente (AT) tesipro (DOT) com> wrote

Have you looked at xp_sendmail?

http://msdn.microsoft.com/library/de...aa-sz_6hbg.asp

Have you also looked at

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


--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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
"Vicente Fuentes" <vicente (AT) tesipro (DOT) com> wrote

Personally I workaround xp_sendmail, by using xp_smtop_senmail
(http://www.sqldev.net)

Whilst it does not offer @query support natively this can be simulated
through the use of an external export mechanism such as DTS, and then
attaching the file, or us the web assistant stored procedures to produce
an Html file of results which can be used as the message body for an
Html email in xp_smtp_sendmail.


In message <eig2nsCYEHA.3944 (AT) tk2msftngp13 (DOT) phx.gbl>, Andy Ball
<andy.ball (AT) remove4spam_greenfell (DOT) com> writes
--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org