Script to move a txt file to another folder

Question

Viewing 4 posts - 1 through 3 (of 3 total)

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

prashant-507002 SSC Eights! Points: 922 More actions · Answer 1

kyle.doouss SSCommitted Points: 1513 More actions · Answer 2

Thanks for your response. The SSIS packages look good. I need to look at these further.

For the moment I created the below which seems to work

DECLARE @cmdmove as varchar(1000)

set @cmdmove= 'MOVE D:\WebFiles\Web_File_Order_In\hello.txt D:\WebFiles\Web_File_Order_In\Processed\hello.txt'

EXEC master..xp_cmdshell @cmdmove

prashant-507002 SSC Eights! Points: 922 More actions · Answer 3

But for this you need administrative privilege to drives.