SSIS – Send HTML Email from Package

The quick answer: Use a script task to use C# or VB.NET to send the email.

Back to the details…

Say we wanted to send a simple HTML email from our package that has a table like this:

From using HTML like this:

When sending an email from a package, usually everyone’s first thought is to use a Send Mail Task. Unfortunately, they only send plain text emails, and who really wants to see those.

However, you can utilize the Script Task to do that for you if needed:

You should then get something like the table above.

Hopefully that helps! Happy coding!