batch job for mailing out hundreds of mails....

[Cheong Sin]

Hi, I like to ask what can be an ideal solution for this type of situation?
We need to schedule a job every night that will basically extract data from
the DB and mail that out to our clients. I am thinking of creating DTS
package and using VBscript to instantiate SMTP object or creating a
standardalone EXE that will basically do the same thing. I was wondering
if there are any other better way to do this like using webservices or other
technology that I can take advantage of. Thanks for you help.

 

[Nicholas Paldino [.NET/C# MVP]]

Cheong,

You can look into the task scheduling API to see how you can register
your program/component to have tasks run on it after a pre-determined amount
of time. DTS and Web Services wouldn't really help here. When your
component is involed through the task scheduling API, you would just query
the database, and perform the emailing as you need to.

Hope this helps.