Maintance plans corrupted with sp2… | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Maintance plans corrupted with sp2…

I installed sp2 on my sql server2005. It failed on database engine service. And i am not able to open my maintance plans or create new plans.
When i try to open existing plan i am getting the following error:
Unable to cast COM object of type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass’ to interface type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSContainer90’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{8BDFE892-E9D8-4D23-9739-DA807BCDC2AC}’ failed due to the following error: Interface not registered (Exception from HRESULT: 0x80040155). (Microsoft.SqlServer.ManagedDTS)
Any help appreciated…[:0][:0] kIRAN
SQL DBA
See if re-registering the DTS.DLL helps.. regsvr32 “C:program FilesMicrosoft SQL Server90DTSBinnDTS.dll"
***********************
Dinakar Nethi
SQL Server MVP
***********************
yup, that fixed it for me.
thanks Dinakar!
]]>