SMTP Connection

Overview

SMTP Connection Manager is SSIS Connection Manager for establishing connections with SMTP-enabled mail servers. Use the API to build components based on SMTP Connection Manager.

Setup

Use the SMTP Connection Manager dialog to specify properties to send mails.

Server Options

Connection Type

Specify connection type. This property has the options listed in the following table.

Value	Description
Unsecure	Unsecured SMTP connection.
ExplicitSSL	Use Explicit SSL SMTP.
ImplicitSSL	Use Implicit SSL SMTP.
ExplicitTLS	Use Explicit TLS SMTP.
ImplicitTLS	Use Implicit TLS SMTP.

Host

Specify the name or IP address of the SMTP server.

Port

Specify the port number on the SMTP server to use for the connection. The default value of this property is 25.

User name

Specify user name to access SMTP mail server. Optional.

Password

Specify password to access SMTP mail server. Optional.

Time-out (secs)

Specify the number of seconds before timing out session connect. The default value of this property is 100 seconds.

RetainSameConnection

Specify if all clients should use the same connection. This property has the options listed in the following table.

Value	Description
True	All clients use same connection (default).
False	Every client use different connection.

Test Connection

Confirm connection manager configuration by clicking Test Connection.

Advanced Options

Authentication

Specify authentication algorithm. This property has the options listed in the following table.

Value	Description
Auto	Automatically determines and uses the most secure available method.
Plain	Uses TLS plain text authentication.
DigestMD5	Uses DIGEST-MD5 authentication.
CramMD5	Uses CRAM-MD5 authentication.
Login	Uses login authentication.
Ntlm	Uses NTLM authentication.
GssApi	Uses GSSAPI/SSPI authentication.
NoAuthentication	Authentication is not used. (1.5 SR-2)

Verbose log

Specify verbose log file name for investigating SMTP connection issues.

Proxy Options

Host

Specify the name or IP address of the proxy server. If not specified, proxy server is not used.

Port

Specify the port number on the proxy server to use for the connection.

User name

Specify user name to access the proxy server.

Password

Specify password to access the proxy server.