Schedule Query and Export Is it possible, to schedule a simple Query to run Daily and export the received data into an excel file?
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