.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Imran Ghani

Home >> Articles >> DataBase >> Post New Resource Bookmark and Share   

 Subscribe to Articles

How to send Email using Send Mail Task of SSIS

Posted By:Rajeev Kumar Mehta       Posted Date: November 02, 2010    Points: 50    Category: DataBase    URL: http://www.dotnetspark.com  

This article illustrates How to send Email using Send Mail Task of SSIS in step by step

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 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 quries are welcome !!

Rajeev Kumar Mehta


Email - mikkykumar@yahoo.com,mikkykumar@gmail.com





 Subscribe to Articles


Further Readings:


No response found. Be the first to respond this post

Post Comment

You must Sign In To post reply
Find More Articles on C#, ASP.Net, Vb.Net, SQL Server and more Here

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend