can you add CLR procedures?
writing to a file is very, very easy if you add some CLR's;
i've got a simple example out on codeplex that i wrote as a proof of concept:
http://sqlclrexport.codeplex.com/
an example call would be like this; a CLR has access ot any table, temp table or table variable, if it is in scope and the calling user has permissions, of course.
EXECUTE CLR_ExportTableAppendToCSV @TableName = '@Log',
@FilePath = 'C:\Data\Logging',
@FileName = 'Procedure_logging.csv',
@IncludeHeaders = 1
Lowell