Копирование файла

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;