Unzip only a single file from all the files using Execute Process Task
-
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?
-
Which tool are you using to perform the unzip? Here's how to do it with 7-Zip, for example.
The absence of evidence is not evidence of absence.
Martin ReesYou can lead a horse to water, but a pencil must be lead.
Stan Laurel -
I am using 7zip.
-
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")
-
Phil,
So should I write the expression like this now? - kashyap4007 - Thursday, September 13, 2018 3:52 PMPhil,
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.
The absence of evidence is not evidence of absence.
Martin ReesYou can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply