How link 2005 SQL server data to a SSIS 2005 package Send Mail task
expert:
new to SSIS. I have a 2005 SQL Server database and a SSIS 2005 package which includes a Send Mail task. I would like to setup the SSIS package with the Send Mail Task to pull a select group of records with the person's name and their email addresses from my SQL database and send an email to each of them automatically and need someone to show me how to this.
http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/66415/