DECLARE @CMD NVARCHAR(4000)
DECLARE @RESULT INT
SET @CMD='"C:\Directory Name\Batch File.BAT" "Parameter One"'
PRINT @CMD
EXEC @RESULT=master..xp_cmdshell @CMD
PRINT ' ... The result code is ' + CAST(@Result AS VARCHAR)
RETURN

"C:\Directory Name\Batch File.BAT" "Parameter One"
output
------------------
The name specified is not recognized as an
internal or external command, operable program or batch file.

(2 row(s) affected)
 ... The result code is 1

exec master..xp_cmdshell 'c:\"Program Files"\"Outlook Express"\TEST.BAT "Parameter One"'

exec master..xp_cmdshell 'C:\"Program Files"\"Pyderion CTI"\ICCS\SERVER\PROGRAMS\GZIP.EXE -dac D:\InetPub\ftproot\ACD\Loc23\040115.Z > "D:\InetPub\ftproot\ACD\Loc23_ACD.DAT"'

output
--------------
Files"Pyderion CTI\ICCS\SERVER\PROGRAMS\GZIP.EXE.gz: No such file or directory

exec master..xp_cmdshell '"C:\Program Files\Pyderion CTI\ICCS\SERVER\PROGRAMS\GZIP.EXE" -dac D:\InetPub\ftproot\ACD\Loc23\040115.Z > D:\InetPub\ftproot\ACD\Loc23_ACD.DAT'

SET NOCOUNT ON
DECLARE @Command   NVARCHAR(4000)
DECLARE @Success   TINYINT
DECLARE @Date      CHAR(6) -- YYMMDD date to be processed
DECLARE @Result    INT
DECLARE @Location  VARCHAR(2)
DECLARE @Directory VARCHAR(30)  -- Points to source data directory when @Location is appended
DECLARE @FileName  VARCHAR(250) -- File name to be imported
DECLARE @ProgDir   VARCHAR(250) -- Pointer to ICCS Server directory

SET NOCOUNT ON
SELECT @Date = CONVERT(char(6),isnull(max(date)+1,getdate()-1),12)  
from hist_que where branch <> 'MAX'

SET @ProgDir = 'C:\"Program Files"\"Pyderion CTI"\ICCS\SERVER\'
SET @Command = N'DEL ' + @ProgDir + 'logs\PkgC2Import.SQL'

PRINT @Command
EXEC @Result = master..xp_cmdshell @Command, NO_OUTPUT
IF @Result=0
BEGIN
  PRINT 'Delete successful.'
END
ELSE
BEGIN
  PRINT 'Delete was unsuccessful.'
  RETURN
END

SET @Location = '23'

SET @Directory = 'D:\InetPub\ftproot\ACD\Loc' + @Location 
SET @FileName = @Directory + '\' + @Date + '.Z'
EXEC @Result=sp_FileExists @FileName

IF @Result=0 -- If the source data has been FTP'ed into the directory for this date and location
BEGIN
  SET @Command = N'DEL ' + @Directory + '_acd.dat'
  PRINT @Command
  EXEC @Result = master..xp_cmdshell @Command -- Delete the output of the GZIP command for this location
  PRINT '.. DEL result code was = ' + cast(@Result as Varchar)
--THIS WORKS: exec master..xp_cmdshell '"C:\Program Files\Pyderion CTI\ICCS\SERVER\PROGRAMS\GZIP.EXE" -dac D:\InetPub\ftproot\ACD\Loc23\040115.Z > D:\InetPub\ftproot\ACD\Loc23_ACD.DAT'

  -- Unzip the LocXX/YYMMDD.Z file into the LocXX_ACD.DAT file, where XX is the location and YYMMDD is the date:
  SET @Command = @ProgDir + 'PROGRAMS\GZIP.EXE -dac ' + @Directory + '\' + @Date + '.Z > ' + @Directory + '_ACD.DAT'
  PRINT @Command
  EXEC @Result = master..xp_cmdshell @Command
  PRINT '.. GZIP result code was = ' + cast(@Result as VARCHAR)
END
SET NOCOUNT OFF