Some tips for the SSIS Send HTML Email Task


Sending an email with HTML can be difficult if you want to be stylish. In this article, we will show you some examples with CSS that will help you send better emails. We will use the HTML Email Task. You can check the article here


Before we perform the steps listed in this article, you will need to make sure the following prerequisites are met:
  1. SSIS designer installed. Sometimes it is referred to as BIDS or SSDT (download it from the Microsoft site).
  2. Basic knowledge of SSIS package development using Microsoft SQL Server Integration Services.
  3. Make sure ZappySys SSIS PowerPack is installed (download it, if you haven't already).
  4. (Optional step). Read this article, if you are planning to deploy packages to a server and schedule their execution later.

First, drag and drop the HTML Email Task. Next, let’s work on formatting and combining rows. This will help create more flexible tables within the email. After making these changes, you can use the preview button to check the result.

Note: Make sure the <style> is the first thing you use in the body of the email.

HTML trick tables

Example for the tables

In the following example, we’ll demonstrate how to modify the email’s body and text, including changing colors, size, and font styles for specific text elements.

HTML trick strings

Example with font, color and background

After implementing these changes, this is how your email will appear. Please note that this is just an example, and you have various options to further customize your email.


In conclusion, CSS can transform your emails into more visually appealing and effective communication tools. For more information on using CSS in HTML files, you can explore this resource here. With CSS, you can create even more impressive email examples

Posted in SSIS PowerPack, SSIS Tips & How-Tos.