Create zip file from SQL Server
11,776
The ^ character is an escape character in the command shell. Try doubling it up.
SET @Command = '"C:\Program Files\WinRAR\Rar.exe" a -ep1 -pasd^^ad ' +@destination+' '+@source
Author by
tungula
Updated on June 28, 2022Comments
-
tungula almost 2 years
Here is code which I use to create a
.rar
file with a passwordDECLARE @source VARCHAR(1000), @destination VARCHAR(1000), @Command VARCHAR(1000) SET @source = 'E:\Temp\testRar.txt' SET @destination = 'E:\Temp\testRar.rar' SET @Command = '"C:\Program Files\WinRAR\Rar.exe" a -ep1 -pasd^ad ' +@destination+' '+@source EXEC MASTER..xp_cmdshell @Command
but it sets
asdad
password and notasd^ad
,^
symbol is ignored. Why?