Unzip only a single file from all the files using Execute Process Task

Question

Post reply

Unzip only a single file from all the files using Execute Process Task

kashyap4007

SSC Eights!

Points: 859
More actions
September 12, 2018 at 11:29 am

#408445

Hi,
I have a zip file and I am using Execute Process Task to Unzip them.
Below is the Expression I am using in the Arguments to Unzip the file.
This is working fine but I don't want to unzip all the files.
I only want to unzip this one file. (T_WC_VOL_2016_AND_LATER) .. Pic showed below.
Can anyone help me with this, please?

Viewing 6 posts - 1 through 6 (of 6 total)

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

Phil Parkin SSC Guru Points: 247180 More actions · Answer 1

Which tool are you using to perform the unzip? Here's how to do it with 7-Zip, for example.

kashyap4007 SSC Eights! Points: 859 More actions · Answer 2

kashyap4007

SSC Eights!

Points: 859

September 12, 2018 at 11:50 am

#2005477

I am using 7zip.

ZZartin SSC-Dedicated Points: 30921 More actions · Answer 3

You can also do it in powershell 🙂

[System.IO.Compression.ZipFileExtensions]::ExtractToFile([IO.Compression.ZipFile]::OpenRead("C:\Test\Compress\testy.zip").GetEntry("New Text document.txt"), "C:\Test\Compress\uncompressed2.txt")

kashyap4007 SSC Eights! Points: 859 More actions · Answer 4

Phil,
So should I write the expression like this now?

Phil Parkin SSC Guru Points: 247180 More actions · Answer 5

kashyap4007 - Thursday, September 13, 2018 3:52 PM
Phil,
So should I write the expression like this now?

This is not something that I remember doing in the past. All I did was find the relevant link for you.

I suggest that you first of all practice getting the command line right outside of SSIS â€“ in a batch file, perhaps.

Once you have that working, you will be in a better position to craft your expression in SSIS. To check/preview how SSIS will evaluate your expression, you can create a new string variable and add the above as the expression for the variable and then click the Evaluate button.