Office365Mail Tasks
Properties Configuration Settings
The Office365Mail Component adds Outlook 365 send and receive capabilities to your SSIS Package.
Remarks
The Office365Mail Task provides a simple way to send and receive emails from Microsoft Outlook 365.
Authorization
To perform OAuth authorization first open the OAuth Authorization dialog by clicking the ellipses (...) button of the OAuthAuthorization property at design time. This will open a dialog. Within the dialog specify the ClientId, ClientSecret, and CallbackURL values for the registered application.
After specifying the necessary values press the Authorize button to authorize the application. This will launch a browser and prompt the user to grant access. After access is granted the task will populate the following values:
All necessary values will be saved in the CacheLocation for use in subsequent requests by the task. The task will use the cached values and will automatically refresh the token if needed. In this way any user interaction is only required at design time, not at runtime.Office365Mail Receive Task
At runtime the task will connect to Outlook 365 and search the emails on the server. All emails that match the Filter will be downloaded and submitted to the SSIS Package as individual messages.
Office365Mail Send Task
The task will connect to Outlook 365 whenever it has a message to send. The contents of the message will be sent in the body of the email, with other fields on the email set through the Message* properties.
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. |
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. |
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. |
OAuthAuthorization | OAuth Authorization Information. |
Other | Defines a set of configuration settings to be used by the component. |
RuntimeLicense | Specifies the component runtime license key. |
Select | The parts of a message that should be retrieved. |
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. |
Timeout | A timeout for the component. |
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. |
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. |
LogFile | The file to write logging information to at runtime. |
LogMode | What information gets logged during component execution. |
MessageBody | The body of the message. |
MessageBodyContentType | The body content type for a message. |
OAuthAuthorization | OAuth Authorization Information. |
Other | Defines a set of configuration settings to be used by the component. |
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). |
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. |
Subject | The subject of the mail message (optional). |
Timeout | A timeout for the component. |
Configuration Settings
The following is a list of configuration settings for the task with short descriptions. Click on the links for further details.
AttachmentName[index] | Filename for the attached file (at index). |
ContinueOnAttachmentError | Whether or not to continue processing messages if an attachment download fails. |
DuplicateAttachmentAction | Specifies what action to take when a duplicate filename is encountered. |
FolderPageSize | Determines the number of folders that will be returned from the server at a time when searching. |
MessageBodyFile | Specifies a file that will be included as the email's body content. |
MessageImportance | Sets the importance of the message. |
MessagePageSize | Determines the number of messages that will be returned from the server at a time when searching. |
MoveTo | Specifies the folder on the server to which messages will be moved. |
UserId | Sets the Id of the mailbox to connect to when accessing a shared mailbox. |
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. |