automate unzip file

[jannat]

Hi all smart people,

I know it's not a real SQL question but since you guys are so smart, I am sure you can help me.

I need to set up a SQL job where I have to insert a jobsstep which will unzip a file and create a text file which will be used in the next jobstep. Does anyone know what should be the command to unzip a file?

Thanks in advance!

[MAK]

It depends on what ZIp software you used to zip that text file.

download PKZIP from www.pkware.com.

That has command line utility.

i dont think WINZIP has command utility. Somebody Correct me if I am wrong.

I believe you have to install an add-on
http://www.winzip.com/wzcline.htm

[MAK]

This will unzip a zip file. If you have a evaluation version, you will get this message

(press any key to continue (Ctrl-C to quit))

--Command
C:\Program Files\WinZip\wzunzip.exe c:\script.zip c:\test

[rmiao]

Yes, winzip has command line add-in.

[jannat]

Thanks Mak, that works.