Yelena Varshal (8/22/2013)

---

The result could be written to a variable per the link in my previous post. Then you can output the variable to a text file with the streamwriter using dts.variables collection

Or you can do it much easier. Creaate your own CLR stored procedure that will write stuff to a file and use it without SSIS as a single SQL Script for both result set output and for the second file.

You can also use bcp out