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

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 - 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


Buy Now Free Trial Download Compare Editions

Task Factory Email Source Adapter

Reads email from a mailbox into a data flow.

Feature Highlights

  • Reads email from a mailbox into a data flow
  • Supports IMAP/POP3
  • Support most email providers (including GMAIL)
  • There is full support for filtering messages based on sender, message to, subject, date received, body and priority.
SSIS Email Source Adapter

SSIS Email Source Adapter- Step 1

The email source UI allows you to setup the properties to read messages from a Pop3/IMAP mailbox. You can setup filtering for all the data coming in from the mailbox to prevent unwanted messages or to target specific messages.


The email source UI allows you to setup the properties to read messages from a Pop3/IMAP mailbox. You can setup filtering for all the data coming in from the mailbox to prevent unwanted messages or to target specific messages.


SSIS Email Source Adapter- Step 2

Email Connection

You must select an email connection manager that will be used to connect and download the messages from the specified mailbox. The selected connection manager must be setup to use either the pop3 or IMAP protocol. 

You can create a new email connection manager by selecting "Create New Connection". For more information on setting up the email connection manager see "Using the Email Connection Manager UI"

Email Connection

You must select an email connection manager that will be used to connect and download the messages from the specified mailbox. The selected connection manager must be setup to use either the pop3 or IMAP protocol. 

You can create a new email connection manager by selecting "Create New Connection". For more information on setting up the email connection manager see "Using the Email Connection Manager UI"

SSIS Email Source Adapter- Step 3

Attachments Directory

The attachments directory is where any attachments for email messages will be stored. Each attachment will be stored in a seperate directory to avoid collisions. The location of each attachment is stored in the "Attachments" column of the Output. 

If the email message has more than one attachment the values will be seperated by semi-colons (;).

For instance, If a message has two attachments named "Attendees.txt" and "prices.csv", then each attachment will be stored in the directory set in the "Attachments Directory" under it's own directory similar. If the value of "Attachments Directory" was set to "C:\temp\attachments" then the files would be stored similar to this:

C:\temp\attachments\4d7bcc3d-517c-43c7-914c-0b0ccf9a5851\attendees.txt
C:\temp\attachments\05b2b528-70b7-4510-a813-239e43244728\price.csv

and the value of the Attachments output column will be "C:\temp\attachments\4d7bcc3d-517c-43c7-914c-0b0ccf9a5851\attendees.txt;C:\temp\attachments\05b2b528-70b7-4510-a813-239e43244728\price.csv"


Attachments Directory

The attachments directory is where any attachments for email messages will be stored. Each attachment will be stored in a seperate directory to avoid collisions. The location of each attachment is stored in the "Attachments" column of the Output. 

If the email message has more than one attachment the values will be seperated by semi-colons (;).

For instance, If a message has two attachments named "Attendees.txt" and "prices.csv", then each attachment will be stored in the directory set in the "Attachments Directory" under it's own directory similar. If the value of "Attachments Directory" was set to "C:\temp\attachments" then the files would be stored similar to this:

C:\temp\attachments\4d7bcc3d-517c-43c7-914c-0b0ccf9a5851\attendees.txt
C:\temp\attachments\05b2b528-70b7-4510-a813-239e43244728\price.csv

and the value of the Attachments output column will be "C:\temp\attachments\4d7bcc3d-517c-43c7-914c-0b0ccf9a5851\attendees.txt;C:\temp\attachments\05b2b528-70b7-4510-a813-239e43244728\price.csv"


SSIS Email Source Adapter- Step 4

Columns Grid

All email source adapters include the following fields to be used by your package:

  • Body - The plain text version of the email
  • BodyHTML - The html version of the email
  • Subject - Subject of the email
  • FromEmail - Email address only of the person who sent the email
  • DateSent - The date the email was sent
  • To - Email address of the account the message was sent to
  • Size - The size in bytes of the message
  • Priority - The priority of the message

Columns Grid

All email source adapters include the following fields to be used by your package:

  • Body - The plain text version of the email
  • BodyHTML - The html version of the email
  • Subject - Subject of the email
  • FromEmail - Email address only of the person who sent the email
  • DateSent - The date the email was sent
  • To - Email address of the account the message was sent to
  • Size - The size in bytes of the message
  • Priority - The priority of the message

SSIS Email Source Adapter- Step 5

Column Filtering

The Email Source UI allow you to filter the data coming in from the source mailbox. There are different filters allowed for different datatypes.

  • String Columns - Allow Contains, Equals, Ends With and Start With filters

Column Filtering

The Email Source UI allow you to filter the data coming in from the source mailbox. There are different filters allowed for different datatypes.

  • String Columns - Allow Contains, Equals, Ends With and Start With filters

SSIS Email Source Adapter- Step 6
  • Integer Columns - Allows Greater Than, Less Than and Equal filters

  • Integer Columns - Allows Greater Than, Less Than and Equal filters

SSIS Email Source Adapter- Step 7
  • Date Columns - Allow After and Before filters

  • Date Columns - Allow After and Before filters

SSIS Email Source Adapter- Step 8

Variable use in Filters

The filter UI allows for the use of variables in the condition textbox. For instance, if there was a variable named "FromEmail" the variable can be used in the filter by appending @@ to the beginning of the variable name to create @@FromEmail.

After a filter is set, the row with the filter set turns green and the pseudo-select statement is updated. This provides you with a quick view of all of the filters that are set.

Variable use in Filters

The filter UI allows for the use of variables in the condition textbox. For instance, if there was a variable named "FromEmail" the variable can be used in the filter by appending @@ to the beginning of the variable name to create @@FromEmail.

After a filter is set, the row with the filter set turns green and the pseudo-select statement is updated. This provides you with a quick view of all of the filters that are set.

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