February 16, 2016 at 12:46 am
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()
February 16, 2016 at 6:17 am
Perhaps the author of the DLL can help you.
February 19, 2016 at 2:36 am
I think any third party DLL's need to be in the GAC for SSIS
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy