Hi All
I am running out in a problem laid before me....
In of the modules of my web Application, I have the requirment of
sending email via DTS Consuming the data thru webservices rather
direct Stored Proc...
Steps:
1.Write A DTS SQL server job
2.Invoke a stored proc thru webservices ....
3.Get the data and send out an email to all the users got from the Web
srvices recordset...
I have not worked with DTS till date .
Can anyone let me know whether is this possible....
Any Help would be highly appreciated...


Regards
Hemlata Shah

You can use xp_smtp_sendmail, to send mail via SMTP. You can get this xp and
examples from http://sqldev.net/xp/xpsmtp.htm

You may want to store the recordset to a temp table and send out the email
for every user in the recordset, by looping through it. Just to give you a
starting point!
--
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/


"Hemlata Shah" <hemlata_shah (AT) yahoo (DOT) com> wrote