Copy file over to server and drop it from source

  • i have a file that i am copying over from server to server daily with a XCOPY batch file. what would the T-SQL be for dropping that file from the source once it has copied over successfully?

     

    Thanks in advance

  • Since you're already using a batch file for the copy, I'd probably use it for the delete as well. Let me introduce you to an excellent batch file resource. For your particular situation, this is the command you're looking for.

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

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