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.
Use the SMTP Connection Manager dialog to specify properties to send mails.
- Test Connection
- Confirm connection manager configuration by clicking Test Connection.
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.
Specify the name or IP address of the SMTP server.
Specify the port number on the SMTP server to use for the connection. The default value of this property is 25.
Specify user name to access SMTP mail server. Optional.
Specify password to access SMTP mail server. Optional.
Specify the number of seconds before timing out session connect. The default value of this property is 100 seconds.
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.
Use the Advanced page of the SMTP Connection Manager dialog to to specify additional properties if your server configuration is different from the default.
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
Specify verbose log file name for investigating SMTP connection issues.
Specify to use command pipelining to significantly reduce network latency when sending a message to lot of recipients (RFC 2920). This property has the options listed in the following table.
Value Description True Use command pipelining (default). False Do not use command pipelining.
Specify to use message data chunking to make sending large emails more efficient and reliable. (RFC 3030). This property has the options listed in the following table.
Value Description True Use message data chunking (default). False Do not use message data chunking.
Use the Proxy page of the SMTP Connection Manager dialog to specify properties if your server is behind firewall.
Specify the name or IP address of the proxy server. If not specified, proxy server is not used.
Specify the port number on the proxy server to use for the connection.
Specify user name to access the proxy server.
Specify password to access the proxy server.
- Where can I find the documentation for the SMTP Connection?
- I get an error "Timeout exceeded"
- Does COZYROC support TLS 1.1 and 1.2 protocols?
- Error Message: The connection type "xxxx" specified for connection manager "xxxx" is not recognized as a valid connection manager type. This error is returned when an attempt is made to create a connection manager for an unknown connection type. Check the spelling in the connection type name.
- New: Support for TLS 1.3.
- New: A new parameter Pipelining.
- New: A new parameter Chunking.
- New: Support for TLS 1.1 and 1.2.
- New: A new option NoAuthentication.
- New: Introduced connection.
Ready to give it a try?
COZYROC SSIS+ Components Suite is free for testing in your development environment.