SSIS: Unzip a Password Protected zip file

In SSIS we don't have a task to Unzip the zipped file,  so we need to find a way to achieve this. In this post i am going to use "WinRAR" to Unzip the zipped file which is password protected.

Note: Make sure WinRAR is installed

• In control flow drag and drop "Execute Process Task" from tool box.
• Edit the task and enter the "Executable, Arguments and WorkingDirectory" details (follow the below sample code)

Zip multiple files:

Executable: 

WinRAR.exe file path (where the WinRAR is installed). 

Default path "C:\Program Files\WinRAR\WinRAR.exe"

Arguments:
e -o+ -pTest123 "D:\Kiran\SSIS\Sample\Kiran.rar"

e -o+ -pTest123                               : e<Space>-o+<Space>-p<Password>

"D:\Kiran\SSIS\Sample\Kiran.rar" : "<Zip file path with extension>"

WorkingDirectory:

Give the Target file path (the unzipped files will store in this location)

Sample Path: D:\Kiran\SSIS\Sample\

See Also:
Zip the file/files with password protection