SQL Server Performance

Maintance plans corrupted with sp2...

Discussion in 'SQL Server DTS-Related Questions' started by thanneerukiran, Mar 19, 2007.

  1. thanneerukiran New Member

    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]

  2. ndinakar Member

    See if re-registering the DTS.DLL helps..

    regsvr32 “C:program FilesMicrosoft SQL Server90DTSBinnDTS.dll"

    Dinakar Nethi
    SQL Server MVP
  3. markeboyle New Member

    yup, that fixed it for me.
    thanks Dinakar!

Share This Page