Script Generate Excel SQL SERVER

Navigation
0

I have a select and I need to generate an excel through it. However there are some observations. I would like this script to run every day at a certain time, 23:55 for example, as it is to get the request data open that day. Another question is where will this excel file go, the bank is on a remote server, I thought of something like that, when I generated the save file in a folder on the network.

Finally, I believe it is not trivial, but if you do not know how to ask the question, right?

    
asked by anonymous 07.03.2018 / 18:06

1 answer

1

Caio, SQL Server has Integration Services (SSIS) that can do this extraction you want, including scheduled and send and / or write wherever you designate.

SQL Server Integration Services [ link

You will need an ETL package with the instructions. [link] p>

You can mount all the necessary flow in the ETL package.

I hope it helps.

    
07.03.2018 / 18:36
SELECT TOP that brings all the results, something like TOP all, exists in SQL Server? Classes Parametrizadas with JUnit 4