Could not load type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100' from assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

Question

WE have SQL Server 2008 64 bit.   We were having issues with attaching database files created in 2008 R2 (Express) and research showed that to resolve this we should also have ExpressR2 installed - which we dutifully did.  (I have since found a better way to handle old databases so no longer need R2 Express).   Anyway now whenever I want to Edit a Plan (BackUPs etc)  I get the following error :   Could not load type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100' from assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'

If I try to create a new plan I ge:  Key cannot be null.   Parameter name Key: (mscorlib)

 

I have yet to uninstall 2008 Express R2 - so far from what I have read it hasn't worked.  Can any one PLEASE help me

Answer 1

do you have another sql server installed other than 2008R2 Express? for example do you have 2008 enterprise or standard?

if yes, try to remove 2008R2 express and try with 2008.

---

http://www.rad.pasfu.com

Answer 2

It seems that your problem is version compatibility.  You do realize that you're asking an older version of SQL (2008) to manipulate data from a newer version of SQL (2008R2)?

You can't do that.

---

Talk to me now on

Answer 3

Is your problem being fixed?

Answer 4

Is your problem being fixed?

I'm still having that problem

I'm using VS 2008 Prof Ed. The SQL Server version is 2005, and I have SSMS 08 locally. But does that affect that? before, it was working perfectly fine

Answer 5

Please post a brand new thread with the particulars of your situation.  You haven't provided nearly enough information here to get assistance...

---

Talk to me now on

Answer 6

This is a "Signing" error message, i found a tips that solve this bug.

See this thread : http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/5383a1e2-3f28-4de4-8ffb-586534bcb3fa

Anyway why this error is not handled by a simple message box like this one ?

"This package was not created on this computer, to use it you must uncheck the digital signature option.

Tools > Options > Business Intelligence Designers > Integration Services Designers > General > Check digital signature when loading a package"

Answer 7

This is a "Signing" error message, i found a tips that solve this bug.

See this thread : http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/5383a1e2-3f28-4de4-8ffb-586534bcb3fa

Anyway why this error is not handled by a simple message box like this one ?

"This package was not created on this computer, to use it you must uncheck the digital signature option.

Tools > Options > Business Intelligence Designers > Integration Services Designers > General > Check digital signature when loading a package"

Awesome trick