Using the Email Connection Manager
The Email Connection Manager is an SSIS connection manager component that can be used to establish connections to an Email server for the purpose of sending emails. Supported protocols are POP3, IMAP and Exchange Web Services. There are two pages of configuration:
- General
- Advanced Settings
To add an Email connection to your SSIS package, right-click the Connection Manager area in your Visual Studio project, and choose "New Connection..." from the context menu. You will be prompted the "Add SSIS Connection Manager" window. Select the "Email (KingswaySoft)" item to add the new Email connection manager.
General Page
The General page on the Email Connection Manager allows you to specify general settings for the connection.
- Server Information
-
- Protocol
-
The Protocol of the email server. The options are POP3, IMAP and Exchange Web Services.
- Host Name
-
The address of the email server.
- SSL Mode
-
Specifies the SSL mode to use when connecting to the server. The options are None, Implicit and Explicit.
- Port
-
The Port of the email server.
-
- Authentication Type (since v21.1)
-
This property is only available for Exchange Web Services Protocol, the available options are:
- Basic
- OAuth 2 (Available for all the protocols - EWS, IMAP nd POP3 since v23.1)
- Email Address
-
User's login name. Provide email address value or domain user name in the format of "domain\username".
- Password
-
The password for authentication of the email server.
- Generate Token File (Available for all the protocols - EWS, IMAP nd POP3 since v23.1)
-
The Generate Token File... button completes the OAuth authentication. After you click this button simply follow the steps in the dialog to generate your token.
- Path To Token File (Available for all the protocols - EWS, IMAP nd POP3 since v23.1)
-
The path to the token file on the file system.
Note: By default you are using the authorization information (Client Id and Client Secret) provided by KingswaySoft for your convenience when setting up the connection, it should NEVER be used for production purposes.
- Token File Password (Available for all the protocols - EWS, IMAP nd POP3 since v23.1)
-
The password to the token file.
- Shared Mailbox (since v4.0)
-
The shared mailbox you want access to. Provide email address value in this field.
Note: this option is only available for Exchange Web Services Protocol.
- Impersonate Mailbox (since v4.0)
-
The Impersonate Mailbox allows you to act as a different user when logged into Exchange Server. Provide email address value in this field.
Note: this option only available for Exchange Web Services Protocol.
- Test Connection Button
-
Use this button to test the connection using the settings you have entered.
Advanced Settings Page
The Advanced Settings page on the Email Connection Manager allows you to specify advanced settings for the connection.
- Proxy Server Information
-
- Proxy Type
-
The type of proxy server. The options are None, Socks4, Socks4a, Socks5, and HttpConnect.
- Proxy Server
-
The address of the proxy server.
- Port
-
The port of the proxy server.
- Proxy Server Authentication
-
- Method
-
The authentication method to use for the proxy server.
- Domain
-
The domain to use for proxy server authentication.
- Username
-
The username for authentication of the proxy server.
- Password
-
The password for authentication of the proxy server.
- Miscellaneous Settings
-
- Timeout
-
The timeout in seconds to use when attempting to connect to the server.
- Force to Use Legacy AES Algorithm
-
The option can be enabled to force to use AES algorithm.