i have ms sql express server so I want to export sql script to export one table to ms excel to one of our shared folder in the network. And I will schedule to run daily at 8:00 am as well.
can you share with me the easiest way to handle it?
Microsoft OfficeDatabasesMicrosoft SQL ServerNetworkingMicrosoft Excel
1. SSIS Packages
2. SQL Server Agent Jobs