sql server dts: I need to write a simple package that executes some SQL and then sends
the result set via email to somebody.

Can anybody explain how I can do this in SSIS or know of a good tutorial
for a newbie?

Hello Mike:
Seems that SSIS might be a bit of overkill for just sending data via email
from a SQL statement. Wouldn't DbMail be a better choice?

Depends on the complexity of the SQL statement, etc.

If you are going to do it in SSIS, you could do the following:
Set up a Data Flow that executes the SQL Statement to retrieve records and
drop them into a flat file. Then on the Control Flow, set up a Send Mail task
and use the file created in the Data Flow as an attachement.

There are LOTS of other possibilities for this. Can you give us more
requirements?

HTH
--
Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]


[quoted text, click to view]