Thom A (12/1/2016)

---

Ok. That's a good start. What your reasoning for choosing to do this via SSIS? I asked as send dbmail is very good at achieving this, especially as your data is located in a table.

As you said, you want to do this with a dataset, SSIS is awful for emailing datasets. MSDN has a good article about using dbmail to send a dataset, table formatted. In a HTML email here: https://msdn.microsoft.com/en-us/library/ms190307.aspx. (sorry I'm on my phone now, IfCode is a pain).

If that looks more like what you're after I'm happy to point you further in the way you want to go.