Average: 3.3 (188 votes)


Overview

Script task to send email thru SMTP server.


Setup

The script has the following parameters:

  • Authentication with Username and Password
  • Support of standard SMTP connection for connection to the server
  • Validation of specified parameters.
  • Support for rich HTML message body.
  • Support for attachments.

11-19-2008 Update: Included support for HTML message.
03-22-2010 Update: Included support for attachments.


Requirements

Depends on System.Net.Mail.SmtpClient for SMTP operations.
Depends on COZYROC Script Task Plus for implementing parameters user interface.


Library references

  • System
  • System.Data
  • Microsoft.SqlServer.ScriptTask
  • Microsoft.SqlServer.ManagedDTS
  • CozyRoc.SSISPlus
  • System.Drawing

ScriptMain