How to Unzip the zipped file

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » How to Unzip the zipped file

How to Unzip the zipped file

Rate Topic

Display Mode

Topic Options

Author

Message

swetha.prachi

Posted Tuesday, February 12, 2013 7:23 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 12:31 AM
Points: 17, Visits: 46

Hi,

I have a WinZip file with the .dat.gz extension and i need to unzip that zip file and extract the files from it.
Can anyone help me out how to do this in ssis 2008?

Thanks

Post #1418958

Abu Dina

Posted Tuesday, February 12, 2013 7:28 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 4:21 PM
Points: 512, Visits: 2,245

How about using the Execute Process Task to trigger the exe to unzip the file?

-----------------------------------
http://www.SQL4n00bs.com

Post #1418962

Mackers

Posted Tuesday, February 12, 2013 7:38 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 4:25 AM
Points: 117, Visits: 473

That's how I do it - see attachment

Mack

Post Attachments

tmp.docx (31 views, 35.33 KB)

Post #1418965

swetha.prachi

Posted Tuesday, February 12, 2013 11:34 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 12:31 AM
Points: 17, Visits: 46

Can you tell what command need to be given?

Post #1419304

swetha.prachi

Posted Tuesday, February 12, 2013 11:35 PM

Grasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 12:31 AM
Points: 17, Visits: 46

It is throwing error [Execute Process Task] Error: In Executing "cmd.exe" "/c wzunzip -o "" """ at "C:\Program Files (x86)\WinZip", The process exit code was "9" while the expected was "0".

Can you pls help me?

Post #1419305

opc.three

Posted Wednesday, February 13, 2013 5:43 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:07 PM
Points: 6,826, Visits: 11,951

iirc exit code 9 means "can't find file" or something like that. Do you have wzunzip installed at the location shown in the example and are the data files you're referencing in the command line exist?

edit: spelling

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1419435

swetha.prachi

Posted Monday, February 25, 2013 2:59 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, June 14, 2013 12:31 AM
Points: 17, Visits: 46

Hi ,

Yes wzunzip is installed in the system

Error Description: In Executing "C:\Program Files (x86)\WinZip\WINZIP32.EXE" " -e -o *.dat.gz" at "D:\Test", The process exit code was "1" while the expected was "0".

Actually when it is run manually it is running when it is run through mainfram job it s throwing this error it is not extracting, can you pls help on this.

Or anyone has a script task to unzip this file? Pls let me know asap

Thanks,
Swetha

Post #1423513

opc.three

Posted Monday, February 25, 2013 9:13 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 1:07 PM
Points: 6,826, Visits: 11,951

What changed? Your last post said error code 9, but this post says exit code 1. Looks like you're calling a different exe now.

What mainframe? Is that just a job scheduler remotely executing a job on a Windows machine? Try logging in as the account the mainframe uses and run the job that way. If there is a problem with permissions that's the simplest way to find it.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1423656

mmartin1

Posted Tuesday, May 07, 2013 11:24 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:25 PM
Points: 198, Visits: 657

Yes wzunzip is installed in the system

Just though I should ask.. Is wzunzip installed on your system or the server you are trying to have run your process?

Post #1450265

« Prev Topic | Next Topic »

Permissions