December 9, 2011 at 7:02 am
How would I do this. Thats the action eg.RENAME etc.
December 9, 2011 at 8:12 am
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
December 9, 2011 at 8:15 am
But for this you need administrative privilege to drives.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply