How to send Email
using Send Mail Task of SSIS
Step .(1) . Create a SSIS Package say SendMailTaskDemo
Step (2). Drag and drop a Send Mail Task Item from Control
Step (3). Right click on the Connection Manager pane and
Select New Connection
Step (4). Select SMTP connection manager and then click Add
Step .(5) . Enter Name,Description and IP of the SMTP Server
and then click ok
Step (6). Now Right click on the Send Mail Task Item and
Step (7). Go to Mail tab of Send Mail Task Editor and then
Select SMTP Connection Manager (the name of the SMTP connection manager) in the
SmtpConnection and also
Enter the From,To,Cc,BCc,Subject etc fields.
There are three types of Message Source Type : Direct
Input,File Connection or Variable.
Direct Input - The message you type in the Message Source
will be the body of the Mail.
File Connection - the content of the message will come from any
file which will become the body of the
Variable - the content of the message will come from any
SSIS variable which will become the body
of the mail.
Here we chose Direct Input
Step (8) .you can also set the Priority : low,High or
normal(default) and any attachments
Click Ok to finish .
Run the Send Mail task to Send the mail to whom u want !!
All quries are welcome !!
Rajeev Kumar Mehta
Email - firstname.lastname@example.org,email@example.com