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 email. Supported protocols are POP3, IMAP and Exchange Web Services.

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.

New Connection

Add Email Connection Manager

General page

The General page on the Email Connection Manager allows you to specify general settings for the connection.

SSIS Email Connection Manager

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.

Email Address

The email address that you want to receive emails for.

Password

The password for authentication of the email server.

Shared Mailbox (since v4.0)

The shared mailbox you want access to.

Note: this option 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. 

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

The Advanced Settings page on the Email Connection Manager allows you to specify advanced settings for the connection.

SSIS email connection manager advanced settings

Proxy Type

The type of the proxy server.  The options are None, Socks4, Socks4a, Socks5, HttpConnect.

Proxy Server

The address of the proxy server.

Port

The port of the proxy server.

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.

Timeout

The timeout in seconds to use when attempting to connect to the server.