How to set up an SSIS Send Mail Task

This is a simple how-to-guide of how to set up a Send Mail Task in SSIS. It is widely used to send out an email to inform administrators if the package runs failed or an error is caught. Just follow the steps below to see how to create the task to send out an email.

1. Create a new package in solution LearnSSIS1 and rename it to SendMail.dtsx.

2. Open the package if it is closed. Drag and drop the Send Mail Task to the package.

3. Right click the task and choose "Edit..." to open the Send Mail Task Editor. In General tab, Change the name to "Send Mail Test" and the description to "Send an email".

4. Click Mail tab, then click the drop-down list in "SmtpConnection" and choose "" to open SMTP Connection Manager Editor.

NB! Talk to your Systems Administrators to find out what's the IP of your SMTP server and what configuration you might need here. After talking to mine I realised that everything was preconfigured and I only needed to add the IP.

5. Input your SMTP server and click "OK" button. Input an email addresses in From which means the email address sent from. Then click "OK".

6. Provide an email address you want to send “From” and the recipients. “Cc” and “BCc” fields are optional.

7. Please make sure you provide a “Subject” and a “Message Source” as well.