SQL2005: Automated Query and send Emails

I am trying to create a system that would automatically run a query and return results based on a date field of when something is due. Then send out an email with some simple text to each of the records it found (the record would contain the specific email address).

In SQL2000 I would have written a DTS Package but DTS does not exist in SQL2005 and I am totally lost.

Who is Participating?
BrandonGalderisiConnect With a Mentor Commented:
SSIS is the replacement for DTS in SQL 2005.
Mitchel-TAuthor Commented:
Yes...I see that, but can you offer any tips or a tutorial as to how it can be done?
I don't work in SSIS so I won't be of much help there.  All I can say is it should not be THAT different than DTS.

You could always do a simple stored procedure that runs the SQL and uses xp_sendmail to do your mailing.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.