Because i using dynamic query mechanism to get the columns dynamically.

Dynamic Query will not run until it has the value in the parameter.

I tried but not solving the problem.

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...