DECLARE @SourceFile AS VARCHAR(500);
DECLARE @DestinationFile AS VARCHAR(500);
DECLARE @Cmd AS VARCHAR(500);
SET @SourceFile = ‘\\SourceFileName’;
SET @DestinationFile = ‘DestinationFileName’;
SET @Cmd = ‘COPY “‘ + @SourceFile + ‘” “‘ + @DestinationFile + ‘”‘;
EXEC master.dbo.xp_cmdshell @Cmd;
