unzip password protected files - SSDT - .net 4.5

• arkiboys

  Hall of Fame

  Points: 3958

  More actions

  February 16, 2016 at 12:46 am

  #304676

  I have started using the dotnetzip from codeplex ...

  Downloaded it and in ssis script task referencing Ionic.ZIP.dll

  in script, I am using using Ionic.ZIP and then in the main:

  public void Main()

  {

  string zipFullPath = Dts.Variables["User::FileNameFullPathZIP"].Value.ToString();

  string zipFullPath_Input = Dts.Variables["User::FileNamePathZIP_Input"].Value.ToString();

  string zipPassword = Dts.Variables["User::Password"].Value.ToString();

  // extract all files into

  using (var zip = ZipFile.Read(zipFullPath))

  {

  zip.Password = zipPassword;

  zip.ExtractAll(zipFullPath_Input);

  }

  Dts.TaskResult = (int)ScriptResults.Success;

  }

  but I get the following error:

  at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

  at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

  at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

  at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Binder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers, CultureInfo culture, String[] namedParams)

  at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteScript()

• Phil Parkin

  SSC Guru

  Points: 246979

  More actions

  February 16, 2016 at 6:17 am

  #1858954

  Perhaps the author of the DLL can help you.

  The absence of evidence is not evidence of absence.
  Martin Rees

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel

• adelio.stevanato 21159

  SSC Enthusiast

  Points: 194

  More actions

  February 19, 2016 at 2:36 am

  #1859746

  I think any third party DLL's need to be in the GAC for SSIS