The SMTP Connection Manager is an SSIS connection manager component that can be used to establish connections to an SMTP server for the purpose of sending email.
To add an SMTP 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 "SMTP" item to add the new SMTP connection manager.
The General page on the SMTP Connection Manager allows you to specify general settings for the connection.
The SMTP server URL.
The SMTP server port number.
- Enable SSL
Specifies whether or not to use SSL encryption when connecting to the SMTP server.
The username for authentication to the SMTP server.
The password for authentication to the SMTP server.
- Timeout (secs)
The Timeout (secs) option allows you to specify a timeout value in seconds for the connection. The default value is 120 seconds.