DECLARE @SourceFileName varchar(255)
Declare @Destination varchar(255)
DECLARE @ExecCmd VARCHAR(255)
SET @SourceFileName = '"\LoadFile.txt"'
set @Destination = '"\LoadFile.txt"'
SET @ExecCmd = 'move ' + @SourceFileName +' '+@Destination
EXEC master.dbo.xp_cmdshell @ExecCmd
make sure your xp_cmdshell command is enabled in...