0

I'm using SSMS 2012. I'm running set of SQL scripts on a remote desktop on a daily basis and backing up the data to an Excel spreadsheet.

I would like to automate the process where the SQL scripts are executed automatically and the results are backed up to an separate Excel sheets daily. How can I automate this?

Rosa
  • 642
  • 6
  • 20
Raja
  • 85
  • 1
  • 1
  • 7

1 Answers1

0

1) Use SQL Server Management Studio Select the database that contains the table that is the target.

2) Right Click and select Import Data. Finish the GUI and save the generated SSIS package on the file system.

3) Execute the SSIS package generated in step 2 using the dtexec command.

4) Use the built in 'at' command (Windows scheduler) or Task Scheduler to execute the package every day.

benjamin moskovits
  • 5,261
  • 1
  • 12
  • 22