How to copy a file from source to destination in SQL SERVER

Note : give below commands for enable  xp_cmdshell

(Stored Procudure). First of all we have Enable Inbuilt Stored Procedure.

EXEC master.dbo.sp_configure 'show advanced options', 1

RECONFIGURE

EXEC master.dbo.sp_configure 'xp_cmdshell', 1

RECONFIGURE

Exec master.dbo.xp_cmdshell 'Copy c:\source\*.sql c:\destination'