SQLTeam.com | Weblogs | Forums

Export Result to Excel on a daily base Automatically

How to create a job or use export wizard to export result of a query to Excel on a daily base automatically on SQL server 2016? Basically I want to get an excel file generated daily for a query and get saved in a particular location without manually exporting the result daily. Thanks.

welcome to the forum

you have many options

  1. ssis
  2. powershell
  3. python

Which one are you more comfortable with?

I've not used either but I could use SSIS or Powershell if I'm given step by step procedure. Sorry for not being a pro but I've never used either of them before. I though I could have done this by scheduling a task or something of this sort but couldn't find the right options

google is your friend

https://gallery.technet.microsoft.com/scriptcenter/PowerShell-Export-SQL-Data-67bcb690