Cannot create ActiveX component

Jul 6, 2010 at 4:42 PM

Hi
I have devloped the application to zip and unzip files using dotnetzip Lib. It warks great on the development server. However it is giving me error " Cannot create ActiveX component."
Installed and registered several time. Environment is 2003 64bit. Just hitting the wall. Tried to on other test server with same configuration same problem. It works fine through the code. Just cannot make it work when deployed through SSIS package.

Any cluse or pointer will be very helpfull.

 chocking at  

zip = CreateObject("Ionic.Zip.ZipFile")

 

SAMPLE  CODE.

   Dim zip
        Try

 


            zip = CreateObject("Ionic.Zip.ZipFile")
            zip.Initialize(pathToZipFile)

 

            If sFileZipPass.Trim <> "" Then
                '   If zip.Encryption <> 0 Then
                zip.Password = sFileZipPass
                'End If
            End If
            zip.ExtractAll(extractLocation, 1)
            zip.Dispose()

 

 

 

 

ERROR

 

 

Description: System.Reflection.TargetInvocationException: Exception has been
thrown by the target of an invocation. ---> System.Exception: Cannot create Acti
veX component.
   at ST_c4e5b7df093d4e9bacdcf7dacaa5b923.vbproj.ScriptMain.Main()
   --- End of inner exception stack trace ---
   at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] argum
ents, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle
 typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invoke
Attr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisib
ilityChecks)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invoke
Attr, Binder binder, Object[] parameters, CultureInfo culture)
   at System.RuntimeType.InvokeMember(String name, BindingFlags bindingFlags, Bi
nder binder, Object target, Object[] providedArgs, ParameterModifier[] modifiers
, CultureInfo culture, String[] namedParams)
   at Microsoft.SqlServer.Dts.Tasks.ScriptTask.VSTATaskScriptingEngine.ExecuteSc
ript()
End Error

 

 

 

 PLEASE HELP!!!!!!!!!

 

 

 

Coordinator
Jul 12, 2010 at 9:07 PM
Sounds to me like you need to register the DotNetZip dll for COM use, on the "production" server. This is something that happens automatically when you install the Dotnetzip Devkit or runtime package. If you want to do that manually, consult the documentation for how to do that. You'll need to use the regasm.exe command. If you're not clear on what it means to "register the DLL" , then you should read the DotNetZip documentation on that to understand more.