I have a sql statement exampl
SELECT company, count(distinct employees) from mytable
group by company
order by company
In a SSIS package I would like to send a email out to recipients with the result from that query
I know i would have to create a variable then call that variable from my send email task.
How would i incorporate the above sql into an expression to create my variable. [SQLFetchData]