Floating FB popout byF5debug

SQL Server Integration Services (SSIS) – Part 11 – Send Mail in SSIS Packages

 

This is part 11 of the series of article on SSIS

Introduction

In this article we are going to see on how to send a mail from SSIS using the SMTP services. This send mail concept is used in real time when the packages are automated and to notify the end user at certain circumstances about the execution process or also about any failure in process or any things need to be skipped as the business needs.  We have an option here as Send Mail Task which is used to perform the task which have been discussed. Let’s discuss in detail about this task.

This article will show on how to set the configuration for the send mail option and send a test mail to the end user.

You can look into my series of article on SSIS at the url - http://f5debug.net/tutorial/ssis.aspx

[more]

Steps

Follow steps 1 to 3 on my first article to open the BIDS project and select the right project to work on integration services project. Once the project is created, we will see on how to use Send Mail Task available with SSIS.

Once you created the project drag and drop the Send Mail Task from the tool box. It will open a pop up as shown in the below screen. It has 3 sections on to that and we will see on how to configure using the options available.

clip_image001

General tab – This section has options to give a name and description for the task similar to the one available in common in all the tasks.

Mail tab – This is the very important section in configuration, here we have many otpions which we need to configure in order to make use of sending mails from the SSIS packages. Check the below screen for example.

clip_image002

You need to give your systems SMTP Server details and from, to and cc mail ids to whoever a mail has to be sent from this package.

When you click on the SMTP new server configuration you will see a window as shown below in order to input the new server details.

clip_image003

Expression tab – This page is used to edit property expressions and to access the Property Expressions Editor and Property Expression Builder dialog boxes.

Once we have configure then we can run the application and see how the mail is sent using SSIS package as shown in the below figure. Running the package will send a mail to the recipients and execute the package successfully.

clip_image004

Conclusion

SO this article helps you to do a send mail task which is very much necessary for a package to execute automatically and send a result to the end users.

About Author: Karthikeyan Anbarasan, Microsoft MVP (Most Valuable Professional) in ASP.NET/IIS Architecture. He is the Founder and Chief Editor of the www.f5debug.net website and has authored books on Windows Phone and Business Intelligence(SSIS). He is also a Passionate Speaker and a Blogger on Microsoft Technologies.

You can Join Me On: Facebook, Twitter, Google Plus, LinkedIn

Comments (2) -

Ankush
Ankush
10/10/2012 4:52:35 AM #

Hi,
Unfortunately even after configuring using the above steps,the package fails throwing me the error:An error occurred with the following error message: "The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. s9sm758239paz.9".

Any idea about this issue?
Appreciated.
A

Julie
Julie
6/2/2013 10:06:17 PM #

It shows error when I try this way..[Send Mail Task] Error: An error occurred with the following error message: "The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. cc15sm61277144pac.1 - gsmtp"

Can you help me in this?

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Recent Posts

Random Posts

Most Viewed

URL Shortner

Create your own short urls!!!

Site Counter

free counters

Disclaimer

This is a personal weblog. The opinions expressed here represent my own and not those of my employer. For accuracy and official reference refer to MSDN/ TechNet. I have documented my personal experience on this blog.

Protected by Copyscape Web Plagiarism Finder

Site Meter