Hi,

 I have written the below code, but It is not working with PKZIP(We cant use WINZIP).

Create procedure [dbo].[sp_ZipFile] @zippedfileName varchar(50),@srcfileName varchar(50)

AS Declare @cmdstr varchar(8000)

Set @cmdstr = 'C:\Progra~1\PKWARE\PKZIPW\pkzipw -add '+ @zippedfile +' ' + @srcfile

exec master..xp_cmdshell @cmdstr

Please suggest me

Arun

Welcome to the forum!

Are you getting any errors?

I do this on a daily basis, so I know it will work.  First off, what version SQL are you running and what version of Windows Server?

Also, if you could post the error and the contents of the @cmdstr that is producing the error would help.

No I am not getting any error, it is running for hrs. I my self is killing the process.

Env : Win2003 server and sql server 2005

 Arun you using PKZIPW?