How would I send a recordset (global variable created with an Execute SQL
task) out via a SendMailTask.

Would the most direct method be, create the SendMailTask via ActiveX code
and loop through the RS building a string var to assign to the
objSendMail.MessageText?

What about creating an output file (TXT or XLS or ....) to attach to the
email. What methods could be used to dump the RS to output?

I am very new to SQL/DTS but have some background in VBA with excel.

Any thoughts are welcome.

--
Regards,
John