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

Posted on 2011-05-09
Last Modified: 2013-11-18
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.
Question by:tcmmaxt
    LVL 59

    Assisted Solution

    by:Kevin Cross

    Short answer: Yes.  You can use Send Mail Task within SSIS:

    LVL 3

    Assisted Solution

    Yes, I agree to mwvisa1.
    LVL 21

    Accepted Solution

    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

    Author Closing Comment

    thank you

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System ( introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
    The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
    The viewer will learn how to count occurrences of each item in an array.
    Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now