Stored procedure to copy physical file to Windows temp path

  • 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?

  • 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.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply