Post reply

Zipping Files

  • April 8, 2003 at 5:59 am

    #63276

    Hi

    I was wondering if anyone has managed to zip files from SQL Server in a stored procedure.

    We are doing a select query to output table then exporting it to text on the server. As we need to email the results out to external people we zip the files up manually at the moment and then send them. I would like to put this into a stored procedure so that it is all handled in 1 job.

  • April 8, 2003 at 6:07 am

    #453441

    Take a look at 'xp_cmdshell' in BOL This should be what you need

    Cheers,

    Frank

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • April 18, 2003 at 11:59 am

    #454685

    -- Install WinZip. It has to be licensed version.

    -- Download and install command line utility wzzip.exe from WinZip site.

    -- Zip file. Delete original.

    set @sCmd= '"c:\Program Files\WinZip\wzzip.exe" -ex -m \\FileServerName\e$\Temp\FileName.zip \\FileServerName\e$\Temp\FileName.txt'

    EXEC @iRetCode = master..xp_cmdshell @sCmd

    IF @iRetCode <> 0

    print('Error')

    There are quite a few command line switches besides the one presented above.

    Voytek

  • November 17, 2010 at 6:48 am

    #1251865

    hi,

    what is FileServerName means? what should i have to give in that?

  • November 17, 2010 at 11:29 am

    #1252057

    I use 7-zip to compress files. Here[/url] I had posted on how to use 7 zip in a script.

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply