5

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.)? – user507 Jul 17 '13 at 13:04
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

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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