SSIS Tutorial Part 134-Extract files from Zip Files & Delete Zip Files once UnZiped in SSIS Package

SSIS Video Scenario:

On daily basis we get zip files those can contain single file or more than one files of different types. We want to create an SSIS Package that can loop through all zip files and extract the files from them and save them to a folder from where we can load them to different destinations in SSIS Package.

In this video we will learn the solution of our given scenario and create an SSIS Package. Below is the list of items we will cover in this video

How to Loop through zip files in SSIS Package
How to create Package Parameters for Zip and UnZip folders and use them in Script Task
How to Change Dot Net Framework from 4 to 4.5 in Script Task
How to add Assemblies such as System.IO.Compression and System.IO.Compression.FileSystem in Script Task
How to Extract Files from Zip file to folder and then delete the zip file in SSIS Package by using Script Task

Blog post link with script for Extract Files from Zip Files

Check out step by Step SQL Server Integration Services(SSIS) Tutorial by TechBrothers

[SwiftCrushing]

Hello TechBrothers! Thank you for all that you have demonstrated in your tutorial videos. You've helped me acquire a new found skill in Beginner - Intermediate SSIS package development, and it's genuinely something that is fun for me. Referencing SSIS 96 (Current Day files), and I believe SSIS 99 (combine the logic from both videos to explain my next point) - Let's say the flag variable is properly utilized, and now we are dealing with a "password-protected" doc file (Current Date in the file name). Starting at 11:21 in this video - How would we add the ability to extract the doc / zip files with password in this same script task? Or does it have to be a foreach loop > Execute process task with argument including password in the expression?

[mohit]

Thank you for your video. I am really glad you are helping us to understand SSIS.

However i have question. The script task give error if input folder has some files. How to manage that ?

Is there way to overwrite it ?

Thanks:)

[talveztelefono]

Great videos, they're really helpful. Thanks.

[dekican]

this was exactly what I needed, thank you.

[vivekkadam]

Thanks it works. It was of great help.

[angelcolon]

What happened when the zip file have a file inside in a particular folder name? This Script will not work. You will have an weird error but when you debug you will obtain something like this: Additional information: Could not find a part of the path So what we can do in these cases?

[frankdo]

hello Sir, how do you Move all the *.Zip files to a different folder, say "Archive" instead of deleting them ?

[safmans]

How would I implement this if one of the .zip containers have another .zip file in it? By using your solution, it just put the zip file in the Destination folder, but did not unzip it. Any thoughts?

[babylon_bob]

This was exactly what I needed, well explained thanks

[abualabedmsncom]

Hi
Thank you for the guide
I have followed the exact same steps that you demonstrate in the video, bus when trying to run the script I get the following message: “The binary code for the script is not found” and that I should try to edit my script in order to correct it.
Do you have any idea what could have went wrong?
Thank you

[dhananjayrele]

I am trying to unzip multiple/all ".gz" files contained within one folder. How can I modify the code to suit my requirement. Any help is appreciated. Thanks.

[bhadauriasingh]

This Article was really very usefull thanks TechBrothers for this article and need one help how to copy latest zip file from source folder and copy to destination and then unzip that zip folder file in destination please help me for this..process if any video or blog available please let me know i will be very thank full to you.

[gregor]

that worked. thanks. thick accent though :)

[rustik]

THank you for the video, however do you have a script to unzip a *.gz files. THank you

[benyams]

"this is the error i get when i execute the task"
at target, Object[] arguments, Signature sig, Boolean constructor)
at obj, Object[] parameters, Object[] arguments)
at obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
at name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)
at