Schedule Query and Export

Question

Is it possible, to schedule a simple Query to run Daily and export the received data into an excel file?

How simple (row count, number of columns, etc.)? – Jul 17 '13 at 13:04 — , Jul 17 '13 at 13:04

score 4 · Accepted Answer · answered Jul 17 '13 at 11:31

4

This can easily be done through an SSIS package and scheduled with SQL Server Agent. See this link for a tutorial/demonstration on the task: http://www.codeproject.com/Articles/402958/SSIS-Package-Export-Data-from-Database-Daily-to-Ne

answered Jul 17 '13 at 11:31

Thomas Stringer

2

...and then see my answer [here](http://dba.stackexchange.com/a/44607/2718) and switch to CSV/TSV. :) – Jon Seigel Jul 17 '13 at 16:38
1

+1 to @JonSeigel's comment. In my opinion, ETL isn't the best process for "pretty" data. Get it into the flat file and then if you need formatting (from Excel or any other formatting source) you can handle it after the fact. – Thomas Stringer Jul 17 '13 at 16:43
Honestly I would have no problem using the Excel Destination if it worked reliably. The issue of component installation is a separate matter, and may be an obstacle as well. – Jon Seigel Jul 17 '13 at 16:57

1 Answers1