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 – https://f5debug.net/tutorial/ssis.php

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.

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.

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.

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.

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.