asked on ms sql excel
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?
can you share with me the easiest way to handle it?
Microsoft OfficeDatabasesMicrosoft SQL ServerNetworkingMicrosoft Excel
Last Comment
Raja Jegan R
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Sorry for the delay in response..
That's why I gave you the last option to use OPENROWSET with Windows Task Scheduler to meet your requirements..
Kindly let me know whether you got a chance to try that one out..
That's why I gave you the last option to use OPENROWSET with Windows Task Scheduler to meet your requirements..
Kindly let me know whether you got a chance to try that one out..
1. SSIS Packages
2. SQL Server Agent Jobs