Avatar of tcmmaxt
tcmmaxt
Flag for United States of America asked on

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.
Microsoft SQL Server 2005Microsoft SQL Server

Avatar of undefined
Last Comment
tcmmaxt

8/22/2022 - Mon
rajvja

SOLUTION
rajvja

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Alpesh Patel

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
tcmmaxt

ASKER
thank you very much
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck