I installed SP2 yesterday on our production server. I had someproblems with that but it seemed to have installed so that the Datbaseengine and the Integration Services is patch at least. But after the update we can no longer bring up the "properties" ofSSIS packages. If we connect to the integration service and choose runpackage the GUI just wait for a while and then nothing happens. We getan error in the event log thou .. Event Type: ErrorEvent Source: .NET Runtime 2.0 Error ReportingEvent Category: NoneEvent ID: 5000Date: 2007-11-12Time: 10:51:07User: N/ADescription:EventType clr20r3, P1 dtexecui.exe, P2 9.0.242.0, P3 45cd726d, P4microsoft.sqlserver.manageddts, P5 9.0.242.0, P6 45cd7534, P7 21, P814, P9 qg0f5oshpmqbs2pm34uokrbhqqrfhscr, P10 NIL. Anyone can make any sense of that? If we open a package that we have scheduled in the SQL Agent we get anerror messages saying "No description found" .. really strange stuffis going on here ..? Please, any help would be appreciated ..

I really really need some help with this one. I can't find anything about this error on google. Think that is a new personal record. /Ola

[Microsoft follow-up]

Update .. Now i can't even start Management Studio .. the good thing is that it seems to be a .net framework related issue and hopefully does not affect the database engine .. Anyway i get this from the log when i try to run Management Studio .. Event Type:ErrorEvent Source:.NET RuntimeEvent Category:NoneEvent ID:1023Date:2007-11-13Time:10:14:44User:N/AComputer:NBPOPRODDBDescription:.NET Runtime version 2.0.50727.832 - Fatal Execution Engine Error (7A0592A2) (80131506) ----- Event Type:ErrorEvent Source:.NET Runtime 2.0 Error ReportingEvent Category:NoneEvent ID:1000Date:2007-11-13Time:10:14:46User:N/AComputer:NBPOPRODDBDescription:Faulting application sqlwb.exe, version 2005.90.3054.0, stamp 46047023, faulting module mscorwks.dll, version 2.0.50727.832, stamp 461f2e2a, debug? 0, fault address 0x000c87cc.

The only thing you can do here is to repair your .NET installation, otherwise most of the SQL Server tools will not work. I would reinstall the entire SQL Server product. Thanks, Bob

Thanks! I will try to repair .net framework. Do you think it can be an idea to try and repair just the Management Studio client tools? /Ola

No,.NET Framework is prerequisite for all the tools. It has to be there before you install other stuff. Thanks, Bob

Hi. I also faced the similar issue, I was getting error while even opening/exporting the dts package from the sql server. I got to know the issue when i checked the event log corresponding to this error. There i could see the same error log as above. In my case the issue was that Microsoft.SqlServer.ManagedDts.dll (the correct version 9.0 something required for sql server 2005 ) was by mistake deleted. but thankfully i got it from recycle bin. Restored it and there i go.