'Send HTML content in Message body in Send mail task in SSIS

I would like to know if there is a way to send HTML content in Message body in Send mail task in SSIS. I'm able to send only string data in message body. I need to generate an automated email with a tabulation from ssis. I found there are other ways to send email from SSIS with HTML body

  1. C# script task using smtp client (tried this and its working)
  2. sending email from sql server

But I need to use send email task in SSIS to perform this. Any suggestions?



Solution 1:[1]

Welcome to StackOverflow Deborah. Same type of question is answered here: SSIS Sending Email with a Link

So SSIS Send Mail Task doesn't support HTML, it's plain text only. Those two options you have listed are the ways to do it.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Gigga