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

Question

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 5 (of 5 total)

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

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

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

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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: 30894 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: 246712 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.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.