Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I'm just getting into sql-server SSIS, so forgive me if this is a basic question. Use the SSISwant to send mail from gmail smtp server.
Smtp host =smtp.gmail.com
port=587 ,
[email protected],
[email protected],
Using the above information I want to send mail from SSIS. How do I use SSIS to do this?
If have any questions please ask.
There is a built in task for sending SMTP mail in SSIS. If you want to use a script task to send mail via SMTP the post below lists several ways to do what you are looking to do.
http://social.msdn.microsoft.com/Forums/en/netfxnetcom/thread/a75533eb-131b-4ff3-a3b2-b6df87c25cc8
As Jason Pointed out, that to send email using SSIS, you have to use Script Task.
Below links with scripts will help you out.
