Send Mail for Each Record in a Select Statement
In Chapter 13 of Microsoft SQL Server 2008 Integration Services, it explains how to send start, end times of a package, etc.
We would like to modify this very simple example in Chapter 13 to incllude the following requirements:
1. Send Mail to an email address and individual's name retrieved from a list retrieved by a select statement.
2. Customize the text in the email to incorporate the individual's name (e.g. Robert or Sarah).
3. Add an variable attachment file (filename and path) based upon the list retrieved by the select statement in item 1.
4. Write a line to a text file for each record processed and the date and time it was processed.