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
- ssis
- powershell
- 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
1 Like