Take the 2-minute tour ×
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.

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
add comment

1 Answer

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

share|improve this answer
2  
...and then see my answer here 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
add comment

Your Answer

 
discard

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.