Unanswered: SQL Server Query Results in a text/xml file
I have written a query that I need to save results of. Is there some statement that I can place at the top of my query (like we can do in Oracle through spool command) to specify the directory\filename to save query results to? Eventually I need to schedule this to run daily via a DTS package.
Please let me know if you've come across this before?