SSIS - How To Unzip .Zip Files In SSIS [ How To Use Execute Process Task In SSIS ]

Scenario:

We download .zip file from FTP site to our computer and then we need to unzip this folder and load all the files in folder to our destination tables.

Solution :

After downloading the .zip file we have to unzip it, to unzip the file we will use Execute Process Task. The executable that we will use to unzip is 7z.exe

Step 1:
Create variables in SSIS Package for Executable location, Zip file location and Uncompressed folder location.


Step 2:
In your SSIS Package, Drag Execute Process Task from Toolbox to Control Flow Pane.
Double Click on Execute Process Task and then go to Expressions Tab.
Under the properties set Executable=@[User::VarExecuteablePath]
and in Arguments set = "x "+ @[User::VarZipFilePath]+" -o"+ @[User::VarUnzipFolderPath]
Click on evaluate expressions and then click OK.
Step 3:
Right Click on Execute Process Task and go to Properties. Set DelayValidation=True

Final Output : 
After executing our SSIS Package we can see that the .zip file is uncompressed to our given folder.



6 comments:

  1. Instead of using Process Task is there any method we can use to load zip files in SSIS?

    ReplyDelete
    Replies
    1. Yes,with ther help of script task and you can use C# or VB coding !

      Delete
  2. I think SSIS is always the best and most useful component to provide more solutions and ideas to complex IT problems.

    SSIS Postgresql Read

    ReplyDelete
  3. The above solution is not working for me . I am getting error as " [Execute Process Task] Error: In Executing "C:\Program Files\7-Zip\7z.exe" "x D:\xxx\xyx 2.zip -oD:\xxx" at "", The process exit code was "2" while the expected was "0". "
    I am using Visual studio 2019 version

    ReplyDelete
  4. I received this error also for same package. "The process exit code was "7" while the expected was "0". " Kindly do the needful.

    ReplyDelete