Send Mail Task

Your rating: None Average: 3.7 (3 votes)

Overview

Script Task to send email thru SMTP server. It includes:

  • 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 component for implementing parameters user interface.

Library references

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

ScriptMain