Unzip password protected file in SSIS using Ionic.Zip dll

1.2k views Asked by At

I got requirement to unzip a file which contains password protected text files in zip file.which have to be done in SSIS package..

I have googled and download a dll called Ionic.Zip to used in script task.

i have used the below code using c# in script task..

  using Ionic.Zip;
  
 

  public void Main()        
  {             
    Dts.TaskResult = (int)ScriptResults.Success;
    start obj= new start();
    obj.decrypt();
  }
  public class start
   {
     public void decrypt()
       {
        string sfilepath ="E:\\shekar\\CIF_Files\\USAGE.zip";                       
                
        ZipFile fileToExtract = new ZipFile(sfilepath);
        fileToExtract.Password = "ftp122";
        fileToExtract.ExtractAll("E:\\shekar\\CIF_Files");
        }
    }

But i am getting an exception msg as below

enter image description here

I Had google a lot. but can't find correct solution. does any one prove me answer

1

There are 1 answers

0
Unbound On

Take a look at the below. It will give you an idea of how it's being used in C# environment. Remember to check all the different Solutions:

link