export data from server to remote location

• musalappa@gmail.com

  Ten Centuries

  Points: 1228

  More actions

  April 19, 2007 at 12:15 pm

  #92387

  hi all,

  I need to export data from SQL server to a folder on the box. problem is that SQL server and box are located on the east coast and I am on the west coast. When I use EM, the data has to come to my local machine and then go back to the server folder. this is causing serious delay. Is there a way for me to route data directly from server to folder without it coming to my computer? I cannt login directly into the machine using VPN or Remote Desktop.

  TIA.

• David McFarland

  SSChampion

  Points: 11815

  More actions

  April 19, 2007 at 12:19 pm

  #701549

  Schedule a job and let SQL Server Agent do the work for you. The account that Agent runs under will need to be able to see the folder.