The Email Source allows you to setup the properties to read messages from a POP3/IMAP mailbox. You can setup filtering for the data coming in from the mailbox to prevent unwanted messages or to target specific messages. See the Email Connection Manager page to learn more about setting up the connection manager.
• Email Connection - Choose and existing Email Connection Manager or select "Create New Connection"
• Attachments Directory - The attachments directory is where any attachments for email messages will be stored. Each attachment will be stored in a separate directory to avoid collisions. The location of each attachment is stored in the "Attachments" column of the Output.
• Messages Variable - The messages variable is an object variable that can be used by the "Delete or Move Messages Task" which allows you to delete messages that we retrieved in the email source.
o Column Name - 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
■ Attachments - The attachments of a message
■ RelatedItems - The items embedded into a message. Usually images in message footers.
o Filter - The Email Source allows you to filter the data coming in from the source mailbox. There are different filters allowed for different data types.
■ String Columns - Allow Contains, Equals, Ends With and Start With filters.
■ Integer Columns - Allows Greater Than, Less Than, and Equal filters
■ Data Columns - Allow After and Before filters
• Condition Textbox - Here you can use variables to use with filtering
The Email Source allows you to filter the data coming from the source mailbox using simple expressions. There are different filters allowed for each data types:
• String Columns - Allows for the usage of the Contains, Equals, Ends With, and Starts With filters
• Integer Columns - Allows for the usage of the Greater Than, Less Than, and Equals filters
• Date Columns - Allows for the usage of the After and Before filters
Additionally, filters allow for the use of variables within the filter's condition textbox. This can be done by appending two ampersats (@@) to the front of the variable name. For instance, the variable named "strFromEmail" could be applied to the "FromEmail" column in the following manner:
After the filters are set, each row that contains a filter will turn green and display a pseudo-select statement that allows for a quick view of all of the filters that are set within the Email Source.