Step 1: Create a SSIS Package say SendMailTaskDemo
Step 2: Drag and drop a Send Mail Task Item from Control Flow Items
Step 3: Right click on the Connection Manager pane and Select New Connection
Step 4: Select SMTP connection manager and then click Add button.
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 Select Edit.
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 mail.
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 queries are welcome !!