Email Tasks
Properties Configuration Settings
The Email Component adds SSL-protected email capability to the SSIS Package.
Remarks
The Email Task provides an all-encompassing email client implementation to your SSIS Package. The task supports both send and receive functionality over multiple protocols.
Email Receive Task
The Email Receive Task implements the IMAP and POP3 internet mail protocols. In order to use the Email Receiver task, you must first select a ServerType. You must also enter a MailServer and User. For servers that require authentication, you will also have to enter a Password.
To activate SSL, you must also select an SSLCert, and set the SSLAcceptServerCert and SSLStartMode. The task will attempt to determine the correct port to connect to based on the server type and SSL settings. However, you may override the default by directly setting the MailPort in the property pages.
Once you have your port set up, the task will connect to the server once every PollingInterval and download messages. To control how the messages are downloaded, or to prevent duplicate messages from being fetched from the mail server, you may set the DeleteMode to an appropriate value. For IMAP connections, you may also set a Filter.
The task will populate the MessageList property with the information retrieved from the downloaded emails.
Email Send Task
The Email Send Task is a complete SMTP client. To send emails from the task you must set at a minimum your SMTPServer, as well as your From and SendTo email addresses. Should you need to guarantee a secure transmission, you may set the SSLCert and SSLStartMode properties, as well as a specific SSLAcceptServerCert.
You may also add carbon copy and blind carbon copy recipients via the Cc and BCc properties. If you wish to receive delivery or read notifications, you can set the DeliveryReceipt and ReadReceipt properties. You may set the Subject of your message. The contents of the outbound message will be sent as the body of the email.
Receiver Property List
The following is the full list of the properties of the receiver task with short descriptions. Click on the links for further details.
AttachmentDirectory | Specifies the directory to which attachments are saved. |
AuthMode | The authentication mode to be used when connecting to the MailServer . |
Delete | Controls if the email is deleted after download. |
Filter | A filter to be applied to the inbox when selecting messages. |
Firewall | A set of properties related to firewall access. |
IncludeHeaders | Instructs the component to include or ignore message headers. |
LogFile | The file to write logging information to at runtime. |
LogMode | What information gets logged during component execution. |
MailFolder | Name of the mailbox selected on the server. |
MailPort | The port of the mail server (IMAP or POP3). |
MailServer | The name or address of the mail server (IMAP or POP3). |
MessageList | String denoting the name of the variable which contains the last message listing entries. |
OAuthAuthorization | OAuth Authorization Information. |
Operation | The operation which will be executed by the Email task. |
Other | Defines a set of configuration settings to be used by the component. |
Password | A password for login. |
PersistentConnection | Instructs the component whether to keep the connection to the server open. |
RuntimeLicense | Specifies the component runtime license key. |
ServerType | The type of server for your email account. |
SSLAcceptServerCert | Instructs the component to unconditionally accept the server certificate that matches the supplied certificate. |
SSLAcceptServerCertAcceptAny | Tells the component to accept any server certificate. |
SSLCert | The certificate to use for client authentication during the SSL handshake. |
SSLStartMode | Determines how the component starts the SSL negotiation. |
Timeout | A timeout for the component. |
User | A user id for login. |
Sender Property List
The following is the full list of the properties of the sender task with short descriptions. Click on the links for further details.
Attachments | Specifies which files the component should include as attachments in the outgoing message. |
AuthMode | The authentication mode to be used when connecting to the MailServer . |
BCc | A comma separated list of addresses for blind carbon copies (optional). |
Cc | A comma separated list of addresses for carbon copies (optional). |
DeliveryReceipt | Whether or not a delivery receipt should be returned to the sender. |
Firewall | A set of properties related to firewall access. |
From | The email address of the sender (required). |
LogFile | The file to write logging information to at runtime. |
LogMode | What information gets logged during component execution. |
MessageHeaders | Message headers associated with the current email message. |
MessageHTML | The HTML text of the message. |
MessageText | The text of the mail message (optional). |
OAuthAuthorization | OAuth Authorization Information. |
Other | Defines a set of configuration settings to be used by the component. |
Password | A password for login. |
PersistentConnection | Instructs the component whether to keep the connection to the server open. |
ReadReceipt | Whether or not a receipt should be sent when the email has been read. |
ReplyTo | A mail address to reply to (optional). |
RuntimeLicense | Specifies the component runtime license key. |
SendTo | A comma separated list of addresses for destinations (required). |
SMTPMessageId | The id of the mail message (optional). |
SMTPPort | The server port for SMTP (default 25). |
SMTPServer | The name or address of a mail server (mail relay). |
SSLAcceptServerCert | Instructs the component to unconditionally accept the server certificate that matches the supplied certificate. |
SSLAcceptServerCertAcceptAny | Tells the component to accept any server certificate. |
SSLCert | The certificate to use for client authentication during the SSL handshake. |
SSLStartMode | Determines how the component starts the SSL negotiation. |
Subject | The subject of the mail message (optional). |
Timeout | A timeout for the component. |
User | A user id for login. |
Configuration Settings
The following is a list of configuration settings for the task with short descriptions. Click on the links for further details.
AddAttachmentsAsMessageParts | Includes attachments as additional parts on the message. |
AttachmentEncoding[index] | Content-Transfer-Encoding for attached file (at index). |
AttachmentName[index] | Filename for the attached file (at index). |
AttachmentNameSource | Specifies the source location in the MIME entity from which the filename is retrieved. |
AutoDecodeHeaders | Whether to decode headers. |
AutoDecodeMessageText | Whether to decode non-MIME message text. |
DuplicateAttachmentAction | Specifies what action to take when a duplicate filename is encountered. |
FoldHeaders | Whether incoming message headers should be folded. |
Logoff | Whether or not to logoff from the server after execution. |
MaskSensitive | Whether sensitive properties should be masked when logging. |
MaxParts | The maximum number of parts to be parsed from a mime message. |
MessageHTMLFile | Specifies a file that will be included as the email's HTML content. |
MoveTo | Specifies the IMAP folder on the server to which messages will be moved. |
ReturnOnlyPlainTextPart | Specifies if the component should return the first plain text part or the entire message. |
ReturnPath | Sets the Return-Path to be used for sending email. |
UIDMode | If True, permanent message identifiers will be used instead of temporary identifiers. |
ReuseSSLSession | Determines if the SSL session is reused. |
SSLCipherStrength | The minimum cipher strength used for bulk encryption. |
SSLEnabledCipherSuites | The cipher suite to be used in an SSL negotiation. |
SSLEnabledProtocols | Used to enable/disable the supported security protocols. |
SSLIncludeCertChain | Whether the entire certificate chain is included in the SSLServerAuthentication event. |
SSLSecurityFlags | Flags that control certificate verification. |
TLS12SignatureAlgorithms | Defines the allowed TLS 1.2 signature algorithms when UseInternalSecurityAPI is True. |
TLS12SupportedGroups | The supported groups for ECC. |
TLS13KeyShareGroups | The groups for which to pregenerate key shares. |
TLS13SignatureAlgorithms | The allowed certificate signature algorithms. |
TLS13SupportedGroups | The supported groups for (EC)DHE key exchange. |
AbsoluteTimeout | Determines whether timeouts are inactivity timeouts or absolute timeouts. |
LocalHost | The name of the local host or user-assigned IP interface through which connections are initiated or accepted. |
TcpNoDelay | Whether or not to delay when sending packets. |
UseInternalSecurityAPI | Tells the component whether or not to use the system security libraries or an internal implementation. |