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.

AttachmentDirectorySpecifies the directory to which attachments are saved.
DeleteControls if the email is deleted after download.
FilterA filter to be applied to the inbox when selecting messages.
FirewallA set of properties related to firewall access.
LogFileThe file to write logging information to at runtime.
LogModeWhat information gets logged during component execution.
MailFolderName of the mailbox selected on the server.
OAuthAuthorizationOAuth Authorization Information.
OtherDefines a set of configuration settings to be used by the component.
RuntimeLicenseSpecifies the component runtime license key.
SelectThe parts of a message that should be retrieved.
SSLAcceptServerCertInstructs the component to unconditionally accept the server certificate that matches the supplied certificate.
SSLAcceptServerCertAcceptAnyTells the component to accept any server certificate.
SSLCertThe certificate to use for client authentication during the SSL handshake.
TimeoutA 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.

AttachmentsSpecifies which files the component should include as attachments in the outgoing message.
BCcA comma separated list of addresses for blind carbon copies (optional).
CcA comma separated list of addresses for carbon copies (optional).
DeliveryReceiptWhether or not a delivery receipt should be returned to the sender.
FirewallA set of properties related to firewall access.
FromThe email address of the sender.
LogFileThe file to write logging information to at runtime.
LogModeWhat information gets logged during component execution.
MessageBodyThe body of the message.
MessageBodyContentTypeThe body content type for a message.
OAuthAuthorizationOAuth Authorization Information.
OtherDefines a set of configuration settings to be used by the component.
ReadReceiptWhether or not a receipt should be sent when the email has been read.
ReplyToA mail address to reply to (optional).
RuntimeLicenseSpecifies the component runtime license key.
SendToA comma separated list of addresses for destinations (required).
SSLAcceptServerCertInstructs the component to unconditionally accept the server certificate that matches the supplied certificate.
SSLAcceptServerCertAcceptAnyTells the component to accept any server certificate.
SSLCertThe certificate to use for client authentication during the SSL handshake.
SubjectThe subject of the mail message (optional).
TimeoutA 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).
ContinueOnAttachmentErrorWhether or not to continue processing messages if an attachment download fails.
DuplicateAttachmentActionSpecifies what action to take when a duplicate filename is encountered.
FolderPageSizeDetermines the number of folders that will be returned from the server at a time when searching.
MessageBodyFileSpecifies a file that will be included as the email's body content.
MessageImportanceSets the importance of the message.
MessagePageSizeDetermines the number of messages that will be returned from the server at a time when searching.
MoveToSpecifies the folder on the server to which messages will be moved.
UserIdSets the Id of the mailbox to connect to when accessing a shared mailbox.
ReuseSSLSessionDetermines if the SSL session is reused.
SSLCipherStrengthThe minimum cipher strength used for bulk encryption.
SSLEnabledCipherSuitesThe cipher suite to be used in an SSL negotiation.
SSLEnabledProtocolsUsed to enable/disable the supported security protocols.
SSLIncludeCertChainWhether the entire certificate chain is included in the SSLServerAuthentication event.
SSLSecurityFlagsFlags that control certificate verification.
TLS12SignatureAlgorithmsDefines the allowed TLS 1.2 signature algorithms when UseInternalSecurityAPI is True.
TLS12SupportedGroupsThe supported groups for ECC.
TLS13KeyShareGroupsThe groups for which to pregenerate key shares.
TLS13SignatureAlgorithmsThe allowed certificate signature algorithms.
TLS13SupportedGroupsThe supported groups for (EC)DHE key exchange.

Copyright (c) 2022 /n software inc. - All rights reserved.
/n software Tasks for SSIS - Version 20.0 [Build 8319]