Stored procedure to copy physical file to Windows temp path

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  November 7, 2018 at 6:08 am

  #372955

  I can get Windows temp path from Path.GetTempPath and PC name.
  Is it possible to copy a file from file server to that PC's temp path using stored procedure or code?

• Joe Torre

  SSChampion

  Points: 10248

  More actions

  November 7, 2018 at 9:34 am

  #2012710

  Yes, using xp_cmdshell or CLR. You could also create a SQL Agent Job to copy or move a file using OS command (.bat, .ps1) or an SSIS package.