We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

SQL2005: Automated Query and send Emails

Mitchel-T
Mitchel-T asked
on
Medium Priority
371 Views
Last Modified: 2012-05-07
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.

Thanks!
Mitch
Comment
Watch Question

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

Commented:
BrandonGalderisi:
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.


http://msdn.microsoft.com/en-us/library/ms189505.aspx
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.