Andras Belokosztolszki (1/22/2008)
A simple question: does this folder actually exist on the server on which SQL Server is running? The xp_cmdshell is executed in the security context of the SQL Server service. Does this have permissions to the folder? So does a simple dir work:
EXEC master..xp_cmdshell 'dir C:\Shippment_Tracking\'
Regards,
Andras
Also check for this :
EXEC master..xp_cmdshell 'dir C:\Shippment_Tracking\Archive\'
I had almost the same situation as you are ( for me i used copy instead of move) i solved my problem by letting the value of the variable in a single line...
I also tested your query i just replaced the path and it works for me..
"-=Still Learning=-"
Lester Policarpio