SMTP Connection Manager
 PreviousNext

SMTP Connection Manager can be used to email using specific SMTP server. This connection manager support custom port and authentication using username/password features (Not found in native SSIS SMTP connection from Microsoft).

Download SSIS PowerPack

Content

Video Tutorial

Coming soon...

Step-By-Step

In this tutorial we will learn how to Create SMTP Connection. You can create multiple connection too.
  1. Before we get started, Credentials of SMTP Server.
  2. Download and Install SSIS ZappySys PowerPack.
  3. Once you finished above steps, Open Visual Studio and Create New SSIS Package Project.
  4. Right click on Connection Managers Panel to Create New SMTP Connection for Server, and Context Menu will appear, Select New Connection from the Context Menu.
    SSIS Create New Connection
  5. Select ZS-SMTP Connection Manager from the Connection Managers list and Click on Add Button.
    SSIS Create New Connection
  6. Now in Connection Manager UI, enter SMTP Server name and unchecked on Anonymous Authentication. Enter correct User Name and Password and Test Email.
    SMTP Connection Manager UI
  7. Click on Test Connection to check configure correct or not.
  8. Click on OK to save SMTP Connection configure setting UI.
  9. Once you finished, you will see SMTP connection in Connection Manager panel.
    SMTP Connection Manager - Execute

Properties

Property Name Description
SmtpServer
EnableSsl
EnableAnonymousAuth
UserName
Port
Password
ConnectionString

Setting UI

SMTP Connection Manager - Setting UI

See Also

References

Copyrights reserved. ZappySys LLC.