Automating SQL Table data transfer RRS feed

  • Question

  • Hi All,

    Currently we are fetching data from SQL tables using simple SELECT commands and copying data to xls file and copying xls files to remote server. Next day the user will use these xls files for some data requirement analysis. 

    Can you please tell me how to automate below tasks in SQL Server.

    Step 1. Execute SQL commands automatically everyday at 12 AM

    Step 2. Save the output of SQL command on local server in the form of CSV/or XLS.

    Step 3. Copy CSV/or XLS file from local server to remote server.

    Step 4: Keep latest xls file on local server and delete old xls file automatically from local server. 

    Thanks in advance.

    Sunday, June 5, 2016 8:52 AM


All replies