• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 322
  • Last Modified:

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.
0
tcmmaxt
Asked:
tcmmaxt
3 Solutions
 
Kevin CrossChief 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
 
GSGDBACommented:
Yes, I agree to mwvisa1.
0
 
Alpesh PatelAssistant 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
 
tcmmaxtAuthor Commented:
thank you
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now