Apparently in my 64-bit environment I can’t execute the following command.
DECLARE @vcCmd VARCHAR(8000) SELECT @vcCmd = '"C:\Program Files\Winzip\WZZIP.exe" -es -a "E:\DATA\test.zip" "E:\DATA\test.dat"' EXEC master..xp_cmdshell @vcCmd = @vcCmd /* 'C:\Program' is not recognized as an internal or external command, operable program or batch file. */
The solution is I can execute other DOS commands, so let’s concatenate them.
DECLARE @vcCmd VARCHAR(8000) SELECT @vcCmd = 'C: && CD "C:\Program Files\Winzip\" && WZZIP.exe -es -a "E:\DATA\test.zip" "E:\DATA\test1.dat"' EXEC master..xp_cmdshell @vcCmd = @vcCmd