Sending HTML formatted email from SSIS (SQL Server Integration Services)
SSIS provides a built-in "Send Mail Task" to send email. The Send Mail Task is quite simple and straight forward in its configuration and use. Click here to learn how to configure and use Send Mail Task in your SSIS Package.
Send Mail Task which is quite simple to use and can be used in a scenario where you need to send plain text email with less development efforts. But you can use, Script Task to overcome the limitations imposed by the Send Mail Task. Click here to see what code you need to write to send HTML formatted mails from SSIS package.