SSIS Send HTML Email Task

SSIS Send HTML Email Task (FREE)

SSIS Send HTML Email Task can be used to send any news letters or great looking HTML emails from SSIS. It support SMTP connection with UserID/Password so you are not stuck with your company email server. Auto expanding placeholders can make it super easy to create flexible email templates in few minutes without messing up with SSIS expressions.

  • Send HTML Formatted email from direct text or template file
  • Support for Placeholders (e.g. just type SSIS variable like {{User::varFirstName}} any where in Body or Subject and at runtime it will be replaced by variable value)
  • This can be used to send news letters or mass emails to customers
  • Support for Custom SMTP connection manager which allows you to enter UserID, Password and Port (There options not present in native SSIS Email Task)
  • Support for RowSet variable place holder. It automatically expands as HTML formatted table in email when variable is object type and content is Recordset or DataTable set from ExecuteSQL task or ScriptTask
Download Help File Buy
View All Tasks Like This
ScreenshotsArticles / Useful LinksSystem Requirements
SSIS Send HTML Email Task - ssis sending results as body of email

SSIS Send HTML Email Task – Using Variable Placeholders (Recordset Resultset in Body)

ssis send mail task with html body

SSIS Send HTML Email Task- Email Preview

SSIS Send HTML Email Task- Edit CSS Style

SSIS Send HTML Email Task – Edit Default CSS Style

SSIS Send HTML Email Task

SSIS Send HTML Email Task – Use ExecuteSQL task to Store RecordSet object. Email recordset as HTML Table

SSIS Send HTML Email Task

SSIS Send HTML Email Task – Email Sent (See recordset variable turned into HTML Table, See how date and Currency formatted)

See Also

Articles/Posts

Amazon Redshift

MySQL to Redshift Data Load Using SSIS

Contents1 Introduction – MySQL to Redshift Load2 Video Tutorial3 Right way but hard way3.1 Steps for Amazon Redshift Data Load from On-Premise files or RDBMS (e.g. MySQL, SQL Server)4 Doing it easy way4.1 Should I use SSIS to load Redshift Database?4.2 Command line approach for MySQL to Redshift data loading5 Setup your Amazon Redshift Cluster6 […]

1 comment

References

  • .net framework 3.5 or higher must be installed
  • SSIS Runtime: To execute SSIS package you will need one or more versions of SQL Server Integration Services 2005/2008/2008 R2/2012/2014 or 2016
  • To design SSIS 2012 package SSDT (VS 2010 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2014 package SSDT-BI (VS 2013 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2016 package SSDT-BI (VS 2015 Shell – SQL Server Data Tools) must be installed.
  • To design SSIS 2005, 2008, 2008 R2 packages BIDS (VS 2005,2008 Shell – Business Intelligence Development Studio) must be installed.
  • Supported Client Operating Systems: Windows 7, Windows 8, Windows 8.1
  • Supported Server Operating Systems: Windows Server 2003/R2, Windows Server 2008/R2, Windows Server 2012/R2

Download View All Tasks Like This