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;
