How do I unzip a file using code in a Script Task in an SSIS package

Question

Post reply

How do I unzip a file using code in a Script Task in an SSIS package

M Shah

SSCommitted

Points: 1683
More actions
January 24, 2007 at 4:57 pm

#72615

How do I unzip a file using code in a Script Task in an SSIS package? Would appreciate any kind of input on this.

Thanks,
Monisha

Viewing 10 posts - 1 through 9 (of 9 total)

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

DiMac SSC Veteran Points: 215 More actions · Answer 1

I would use the Execute Process task and call your Unzip utility as you would from the command line.

Cheers,

Diane

MohammedU SSCoach Points: 19644 More actions · Answer 2

http://p2p.wrox.com/topic.asp?TOPIC_ID=29217

MohammedU
Microsoft SQL Server MVP

M Shah SSCommitted Points: 1683 More actions · Answer 3

Thanks for your input. I will use execute process method, and I do have winzip installed on the box but no winunzip.exe file is a part of that install. This is probably not the right forum for this, but if you have any suggestions at all it will be much appreciated.

Thanks again,

Monisha

PW-201837 SSC-Insane Points: 20805 More actions · Answer 4

Go to the website for winzip and download the optional winzip command line.

The executable "wzunzip.exe" is the command-line unzipper that can be easily called from an exec process task.

M Shah SSCommitted Points: 1683 More actions · Answer 5

wzunzip.exe" is the command-line unzipper is not available for Win 2003 Server. I just checked and we have the Integration Services running on a Win 2003 server.

Any other inputs will be much appreciated.

Thanks.

MohammedU SSCoach Points: 19644 More actions · Answer 6

Check windows COMPACT command with /U switch...

MohammedU
Microsoft SQL Server MVP

M Shah SSCommitted Points: 1683 More actions · Answer 7

The windows compact command with the /u option does not seem to work:

C:\Documents and Settings\Administrator>compact /u "C:\ETL\POSData\IngramWeekly

INVEN.ZIP"

Uncompressing files in C:\ETL\POSData\IngramWeekly\

0 files within 1 directories were uncompressed.

Any other inputs will be appreciated.

MohammedU SSCoach Points: 19644 More actions · Answer 8

Sorry! my bad... I didn't check the correctly that command...

Looks like you are out of luck.... you can use free third party command utilities..

http://www.picozip.com/command-line.html

http://www.7-zip.org/

MohammedU
Microsoft SQL Server MVP

M Shah SSCommitted Points: 1683 More actions · Answer 9

M Shah

SSCommitted

Points: 1683

January 30, 2007 at 11:02 am

#686545

Thanks that helps.