Unzip password protected Zip file in SSIS

Question

Does anyone know how to Unzip password protected files in an SSIS package?

We have an SSIS package that currently use java.util.zip to unzip zip file and has been working perfectly for some time now. They now want to password protect the files and unfortunetly this library cannot do it.

We are using a SQL server 2008 with .Net 3.5 on the windows server 2008 R2.

Answer 1

You would have to write a C# script that has the password and you would be able to unzip it using the built in .Net library.

Answer 2

Use an execute process task and call winzip, IZArc or similar program you can drive from the command line. Use the expressions properties to dynamically set paths and passwords for the command line