Task Factory - Urban Outfitters
"We have found that Task Factory tremendously speeds up the development process and improves performance by means of the high-performance components."

Tim Harris

BI Data Engineer

Urban Outfitters Inc.

Task Factory
"I have found Task Factory to be a huge time saver with SSIS development. The SalesForce components alone saved close to two months of work on a major integration project. I highly recommend!"
Alan Rubel
Database Administrator
Joint Commission Resources
Task Factory Loews Corporation
"We bought the product mostly because of the company's reputation for the service they provide and the specific need of a secure SFTP task."

Matt Cushing

Application Systems Analyst/Developer

Loews Corporation

Greater New York City Area

Task Factory - Mark Marinovic
"We bought Task Factory primarily for the SCD Type 2 task, as it enabled us to do several things the built-in SSIS SCD task did not do. Task Factory comes highly recommended from me as our ROI was reached in just days."

Mark Marinovic

Task Factory - Jay Cole
"I purchase Task Factory over a year ago, and let me tell you, IT WORKS FLAWLESSLY. I haven’t had a single problem with it, and I used to HATE having to make changes with the version you’re using. My advice (for what it’s worth) is to pay the money!"

Jay Cole



Buy Now Free Trial Download Compare Editions More Features

Task Factory Advanced Email and SMS Task

Sends emails from within an SSIS package through SMTP.

Feature Highlights

  • Inbuilt HTML editor for HTML email
  • Supports sending SMS messages
  • Template based email (template can be external file, variable, or direct input)
  • Allows use of User/System Variables as placeholders in the email body so variables can be automatically replaced when an email is sent
Advanced Email and SMS Task

SSIS Advanced HTML & SMS Email Task- Step 1
UI Overview

UI Overview

SSIS Advanced HTML & SMS Email Task- Step 2

Mail Settings

Mail Settings

SSIS Advanced HTML & SMS Email Task- Step 3
  • Subject - The subject of the email being sent
  • From - The email address being used to send the email
  • To -  The email addresses or SMS addresses the email will be sent to
    • The To property can be set to either email addresses or sms

  • Subject - The subject of the email being sent
  • From - The email address being used to send the email
  • To -  The email addresses or SMS addresses the email will be sent to
    • The To property can be set to either email addresses or sms

SSIS Advanced HTML & SMS Email Task- Step 4
  • Using SMS
Enter a phone number and select a service provider

  • Using SMS
Enter a phone number and select a service provider

SSIS Advanced HTML & SMS Email Task- Step 5

SSIS Advanced HTML & SMS Email Task- Step 6
After you select a service provider and enter a phone number you'll click the Add button

After you select a service provider and enter a phone number you'll click the Add button

SSIS Advanced HTML & SMS Email Task- Step 7
After you choose SMS you will get an error stating that plain text should be used. 

After you choose SMS you will get an error stating that plain text should be used. 

SSIS Advanced HTML & SMS Email Task- Step 8
  • Priority - The message priority

  • Priority - The message priority

SSIS Advanced HTML & SMS Email Task- Step 9
  • CC - The CC email addresses
  • BCC - The BCC email address
  • Message Source - The source of the message being sent. There are three options:
    • Direct Input - Uses the message created in the HTML or Plain Text editor in the UI. 
    • File - Uses the file in the File Connection Manager selected.You will be able to edit the file content within the UI. When you click the OK button the file contents are replaced with the contents within the HTML Editor or Plain Text Editor (if Use Plain Text Email checkbox is selected).

  • CC - The CC email addresses
  • BCC - The BCC email address
  • Message Source - The source of the message being sent. There are three options:
    • Direct Input - Uses the message created in the HTML or Plain Text editor in the UI. 
    • File - Uses the file in the File Connection Manager selected.You will be able to edit the file content within the UI. When you click the OK button the file contents are replaced with the contents within the HTML Editor or Plain Text Editor (if Use Plain Text Email checkbox is selected).

SSIS Advanced HTML & SMS Email Task- Step 10
  • Variable - Uses the text contained within the variable selected. The variable text can be edited within the UI. When the OK button is clicked the variable contents are replaced with the contents within the HTML Editor or Plain Text Editor (if Use Plain Text Email checkbox is selected).

  • Variable - Uses the text contained within the variable selected. The variable text can be edited within the UI. When the OK button is clicked the variable contents are replaced with the contents within the HTML Editor or Plain Text Editor (if Use Plain Text Email checkbox is selected).

SSIS Advanced HTML & SMS Email Task- Step 11
  • Attachments - Attachments sent with the email

  • Attachments - Attachments sent with the email

SSIS Advanced HTML & SMS Email Task- Step 12
Once an attachment is added to the message, it will show up in the list. If you want to REMOVE an attachment, uncheck the checkbox and click ok

Once an attachment is added to the message, it will show up in the list. If you want to REMOVE an attachment, uncheck the checkbox and click ok

SSIS Advanced HTML & SMS Email Task- Step 13
  • HTML Editor
    • Message Body  - Used to edit the body of an html email in design mode
    • HTML Source - Used to edit the body of an html email by editing the source.
  • Variables - The package level user variables and system variables can be used within the message being sent. The place holder (e.g. {{User::MyVariable}}) is replace with the value of the variables. For instance, MyVariable contains "1234". This means that {{User::MyVariable}} will be replaced with "1234" when the message is sent out. 

    To add a variable to the message simply click the button next to a variable name:

  • HTML Editor
    • Message Body  - Used to edit the body of an html email in design mode
    • HTML Source - Used to edit the body of an html email by editing the source.
  • Variables - The package level user variables and system variables can be used within the message being sent. The place holder (e.g. {{User::MyVariable}}) is replace with the value of the variables. For instance, MyVariable contains "1234". This means that {{User::MyVariable}} will be replaced with "1234" when the message is sent out. 

    To add a variable to the message simply click the button next to a variable name:

SSIS Advanced HTML & SMS Email Task- Step 14

Then paste it into the message body.

Then paste it into the message body.

SSIS Advanced HTML & SMS Email Task- Step 15

View Our Suite of Pragmatic Works Products
Copyright 2014 by Pragmatic Works