So everything was working grand. I had both SQL2005 and 2008 installed and were working together just fine. Then I installed 2008R2. And everything was still fine minus the fact that I couldn't run anything with the dtexecui.
I have 2 computers that mirror each other in what's installed on them. SQL2005/2008/R2 were installed on both of them. Then when I started having package issues, I uninstalled R2.
Computer A works fine. After I uninstalled R2, I reinstalled the components from the sql2008 disk and packages work/open/run with dtexec/ui
On Computer B (which is the more important one of course) I get this error when trying to open a package (in bids).
Error 4 Error loading 'Package.dtsx' : Could not load type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100' from assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'..
And then it gives me the little red x in the right corner.
I tried re-registering everything based on this post http://social.msdn.microsoft.com/Forums/en-IE/sqlkjsetupandupgrade/thread/5ed7480b-2ca5-48de-bd3b-4b3752237c31 and that didn't work.
Then I uninstalled SQL2008, reinstalled, applied SP1, it still didn't work. Then I re-registered things again and it still d
View Complete Post