I've got the correct syntax now...and its working. But to address your
question....the version of pkzip(4.0) has directions that indicate to use
'pkzipc' ....and thats how the program is run from a dos prompt

-----Original Message-----
From: Long, Charles (euler:eti) [mailto:Charles.[Email Address Removed] Wednesday, June 12, 2002 4:16 AM
To: Conahan, Patrick; '[Email Address Removed] RE: shelling out to use pkzip?


I'm probably missing a point, but why generate PKZIPC rather than PKZIP

> -----Original Message-----
> From: Conahan, Patrick [SMTP:Patrick.[Email Address Removed] Sent: Tuesday, June 11, 2002 7:42 PM
> To: '[Email Address Removed] Subject: shelling out to use pkzip?
>
> I downloaded pkzip 4.0 so that I could zip files from a stored procedure.
> I'm having the obvious problem below. What am I doing wrong? I tried
> fully
> qualifying the executable...but that didn't seem to work....
>
> declare @strCMD1 char(100)
> declare @cmd char(50)
> select @cmd = 'master..xp_cmdshell'
> declare @cmd_par1 char(75)
> declare @cmd_par2 char(75)
>
> select @cmd_par1 = rtrim('"PKZIPC test.zip test.txt"')
>
> print (@cmd + @cmd_par1)
>
> exec (@cmd + @cmd_par1)
>
> master..xp_cmdshell "PKZIPC test.zip
> test.txt"
>
> output
>
> --------------------------------------------------------------------------
> --
> --------------------------------------------------------------------------
> --
> --------------------------------------------------------------------------
> --
> ----------------------'PKZIPC' is not recognized as an internal or
> external
> command,
> operable program or batch file.
>
> (2 row(s) affected)
>
> Patrick Conahan
> Consultant
> Project Implementation &
> Database Support Services
> The TriZetto Group
> Office: 847-887-8080
> Fax: 847-887-8001
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page