Send emails based on query results
2
votes
1
answer
2659
views
I have a request to send emails the first of every month for each department that hasn't submitted their hours. I have a query that generates a list of email addresses, the email subject, and the email body. However, in the Data Flow SSIS Toolbox there is not a "Send Email Task" option like there is in the Control Flow.
How can I send emails based off of my query results?
Asked by DForck42
(3068 rep)
Apr 20, 2017, 07:16 PM
Last activity: Apr 23, 2017, 05:43 PM
Last activity: Apr 23, 2017, 05:43 PM