SQL CLR Libary to produce file output from SQL stored procedures.
Exec Sql2Csv @sql='SELECT 1 as A, 2 as B',@filePath='C:\Temp',@fileName='Test.csv',@includeHeader=1,@delimeter=',',@UseQuoteIdentifier=0,@overWriteExisting=1,@Encoding='UTF-8'--C# encoding names
Exec WtiteToFile @FileName='C:\Temp\Test.txt', @Data='Something to write to the file', @Append=1-- 1 = Append to file if exists, otherwise create a file, 0 = Create or overwrite file