I have to take the output stream from a stored procedure and turn it into a
text file. I do not know how to do this without writing it into a table and
then using the table as a datasource, which seems lame. Is there an easy way
to do this?

Thanks

I have done this using bcp and osql

following link will help u
http://www.sqlteam.com/item.asp?ItemID=744

A Panchanathan

Hello Snake,

So long as the stored proc returns a rowset to the task you will be OK.
remember to set

SET NOCOUNT ON in the proc.

Allan