SQL Server Performance

Unable to to Zip files by SP using PKZIP

Discussion in 'SQL Server 2005 General Developer Questions' started by sharmainbox, Jun 22, 2009.

  1. sharmainbox New Member

    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~1PKWAREPKZIPWpkzipw -add '+ @zippedfile +' ' + @srcfileexec
    master..xp_cmdshell @cmdstr
    Please suggest me
    Arun
    sharmainbox, Jun 22, 2009
    #2

  2. FrankKalis Moderator

    Welcome to the forum!
    Are you getting any errors?
    FrankKalis, Jun 23, 2009
    #3

  3. sharmainbox New Member

    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?
    sharmainbox, Jun 23, 2009
    #4

  4. ws5926 New Member

    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.
    ws5926, Jun 23, 2009
    #5

Share This Page