Post reply

How to unzip the zip file through xp_cmdshell command

  • May 26, 2010 at 11:09 pm

    #221612

    I can view the my system's h:\ drive files through xp_cmdshell 'dir h:\*.*' command. One zip file is available this drive. I can manually unzip that file. But I want unzip that file through xp_cmdshell (using sql 2005).

    How can i unzip that zip file through xp_cmdshell?

    could you please help me for this?

    Thanks in advance..

    Nithiyanandam.S

  • May 26, 2010 at 11:41 pm

    This was removed by the editor as SPAM

  • May 27, 2010 at 12:06 am

    #1173126

    You could also use 7-Zip from Sourceforge ; its as freeware compress/decompress utility that has GUI as well as command line abilities.

    Links : 7-zip offical site[/url]

    7-zip @ Sourceforge[/url]

  • May 27, 2010 at 12:09 am

    #1173127

    Here are some example on how to use 7-zip : 7 Zip Examples from dotnetperls.com

  • May 27, 2010 at 12:14 am

    #1173128

    To add on, the manual right-click-extractall available in Windows is carried out by zipfldr.dll in the background; As DLLs cant be worked over from command line, you have no option that to use either of the software me and stewartc put up.. alternatively, u can also check out WinRaR from rarlab.com[/url] which is yet another powerful but paid software! We, at our desk ,use WinRAR!

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

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