can SSIS be used to fire off an email that's triggered off an sql query

expert:
I have an sql query script that I what to use to fire off email for records that are flagged to send out an email based on certain conditions and the logic. Can this sql script somehow be run in SSIS to send out email.
tcmmaxtAsked:
Who is Participating?
 
Alpesh PatelConnect With a Mentor Assistant ConsultantCommented:
Yes, you can do it.

1. Create SQL Query and get scalar result in Variable (Execute SQL Task)
2. Create Send Mail Task
3. Put condition in between them  Image
0
 
Kevin CrossConnect With a Mentor Chief Technology OfficerCommented:
Hi.

Short answer: Yes.  You can use Send Mail Task within SSIS: http://msdn.microsoft.com/en-us/library/ms142165.aspx

Kevin
0
 
GSGDBAConnect With a Mentor Commented:
Yes, I agree to mwvisa1.
0
 
tcmmaxtAuthor Commented:
thank you
0
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.