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.

Test Connection Button

Use this button to test 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 milliseconds to use when attempting to connect to the server.