Copy a file in SQL Server using xp_cmdshell
Posted on 2014-07-30
I wanted to copy a file with name "mts&Cs, MTC,MLA_77.rar" using xp_cmdshell in SQL Server 2012.
EXEC master..xp_cmdshell 'COPY D:\Source\mts&Cs, MTC,MLA_77.rar E:\Destination'
But, it is giving below error:
The system cannot find the file specified.
'Cs' is not recognized as an internal or external command,
operable program or batch file.
It seems that it does not allow "&", "," and space.
Could you please take a look over it and let me know in case you have other thoughts?