74 How to unzip multiple zip files in SSIS ?

How to unzip multiple zip files in SSIS ?

Working Directory: D:\Files
Arguments: "e "+ @[User::FilePath] +" "

Download the file\script used in the Video from below link

How to unzip multiple zip files in SSIS
How do I unzip a .ZIP file in SSIS?
How do I unzip multiple files?
Can Windows unzip multipart zip?
How do I zip a file in SQL Server?

[kishoreganesh]

Thanks bro it is very helpful in short time

[sankalpbhoir]

Happy Teacher's Day sir.... Thank you for sharing valuable knowledge :)

[SonNguyen-xwyl]

Hi the demo it extract the files can it extract to it own individual folder. Example I have 2 zip files each zip file had it own naming I like to keep the folder name when unzipped it. Thank

[ghiegomez]

This works if ran in SSIS but not in SQL server agent. It's not recognizing the location of the local mapped drive for the 7-zip. I even moved the exe file where my files are stored and giving me the 2 exit and should be 0. I'm stuck. Can you help?

[krishnaveer]

Can u give real time examples of in which cases we can use in look up full cache, partial cache and no cache.

[santhoshsomu]

How to unzip the file into same folder.
Example i got emp.zip with 3 files i have to unzip the files to new filder emp

[ravikiran]

I have one scenario that we have files in client-side server on Monday client given one file to run then Tuesday he didn't give the file on Wednesday files was come to both Tuesday and Wednesday file how to load files sequentially from Tuesday and Wednesday

[jagmohansolanki]

Hello sir, while executing package I'm getting below error
16:10:22:291 SSIS package starting.
16:10:23:275 Error: 0xC0029151 at Execute Process Task, Execute Process Task: In Executing "C:\Program Files (x86)\Lenovo\System Update\7za.exe" "e F:\Jagmohan\SSIS\74 How to unzip multiple zip files in SSIS\Addresses.zip " at "F:\Jagmohan\SSIS\74 How to unzip multiple zip files in SSIS\jms", The process exit code was "2" while the expected was "0".
16:10:23:275 Task failed: Execute Process Task
16:10:23:275 Warning: 0x80019002 at Foreach Loop Container: SSIS Warning Code The Execution method succeeded, but the number of errors raised (1) reached the maximum allowed (1); resulting in failure. This occurs when the number of errors reaches the number specified in MaximumErrorCount. Change the MaximumErrorCount or fix the errors.
16:10:23:275 SSIS package finished: Success.
16:10:25:797 The program '[20864] DtsDebugHost.exe: DTS' has exited with code 0 (0x0).