I'd like to save the output of queries in SQL Server 2014 to csv files, but I'd like it to be automatic. Is that possible? Thank you in advance.
Asked
Active
Viewed 1,095 times
0
-
2What are you using to execute your queries? – David Rushton Feb 07 '17 at 16:55
-
1Similar to this question: http://stackoverflow.com/questions/16079666/how-to-produce-an-csv-output-file-from-stored-procedure-in-sql-server. I would suggest that if you can wrap all of this up in a stored procedure then you could use SQL Agent to schedule it, then it would be automatic? – Richard Hansell Feb 07 '17 at 17:04