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.
-
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.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply