CODEWITHSUNDEEP
ssis
MarcoF
MarcoF

Reputation: 205

Unzip password protected Zip file in SSIS

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.

Upvotes: 2

Views: 2129

Answers (4)

Leif
Leif

Reputation: 11

I have enjoyed using DotNetZip, it's free, has rich functionality and is well documented

DotNetZip

examples of using it in SSIS

Upvotes: 1

Mark
Mark

Reputation: 9428

PragmaticWorks have a "TF Compression Task" in their Task Factory suite which handles password protected zip files very nicely. You'll need to buy a sever license to use their suite in production, but you can download and use it free within VS2008 BIDS.

I've got a licensed copy of Task Factory and would recommend it to anyone who uses SSIS in a corporate environment.

Upvotes: 0

SPE109
SPE109

Reputation: 2951

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

Upvotes: 0

Josef Richberg
Josef Richberg

Reputation: 613

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.

Upvotes: 0

Related Questions