How link 2005 SQL server data to a SSIS 2005  package Send Mail task

tcmmaxt
tcmmaxt used Ask the Experts™
on
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.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Or you can send mail using....

http://www.mssqltips.com/tip.asp?tip=1731
Solution Architect at TCS (SAFe®Agilist, TOGAF® Foundation, PSM I®, MCP, MCSD)
Commented:
Please see attached images Image 1 Image 2

Author

Commented:
thank you very much

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial