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


Top 5 Contributors of the Month
david stephan

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:

Responses

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