5

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

Jon Seigel
  • 16,922
  • 6
  • 45
  • 85
TheJoeIaut
  • 205
  • 3
  • 5

1 Answers1

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

Thomas Stringer
  • 42,434
  • 9
  • 120
  • 155