Thanks for the reply, Cheeso
Unfortunately i can't set the property my creatobject statement blows out with Invalid procedure call or argument.
I've looked at the default constructor in the source and i can't see anything here could cause the issue.
The really strange thing is that sometimes it works and sometimes it doesn't, On other test servers it creates the object perfectly .
The process is running under a SqlAgentJob, the jobs owner is part of the sysadmin fixed role hence should have full server permissions
Perhaps its something to do with registering the object
here is how i register and unregister via a bat files .....
gacutil -i D:\Bin\DotNetZip\22.214.171.124\Ionic.Zip.dll
gacutil -u Ionic.Zip
regasm D:\Bin\DotNetZip\126.96.36.199\Ionic.Zip.dll /u
I would apprecaite any further insight