Send html emails with SSIS

GOAL: send an html email using Sql Server Integration Service PROBLEM: the Send Mail Task in SSIS allows only email in text format and not in html format. SOLUTION: use a C# script instead the Send Mail Task to create and send the email. Add a Scrip...