How you can send HTML email messages from SSIS?
-
Using the Send Mail control task
-
Using a script control task
-
Using Database Mail
-
You cannot send HTML mails from SSIS
Reveal answer
Fill a bubble to check yourself
B
Correct answer
Explanation
The Send Mail Task in SSIS only supports plain text emails. To send HTML-formatted emails, you must use a Script Task with .NET code to access System.Net.Mail and set IsBodyHtml=true.
AI explanation
The built-in Send Mail Task in SSIS can only send plain-text messages, so to send HTML-formatted email you need to write custom code in a Script Task (using an SMTP client) to construct and send the HTML message. Database Mail is a SQL Server feature invoked separately, not a native SSIS control flow option for this.