Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

share|improve this question
How simple (row count, number of columns, etc.)? – Shawn Melton Jul 17 '13 at 13:04
up vote 4 down vote accepted

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:

share|improve this answer
...and then see my answer here and switch to CSV/TSV. :) – Jon Seigel Jul 17 '13 at 16:38
+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

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.