I did 2 things to fix this, first I installed the latest SQL Server SP2 Hotfix (you must be on SP2 prior to installing hotfix). Then I restarted and my error msg changed a little. Below is the new error msg and fix: Background. When trying to create new or modify existing maintenance plans in Microsoft SQL 2005 SQL Server Management Studio you may get the 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: Library not registered. (Exception from HRESULT: 0×8002801D (TYPE_E_LIBNOTREGISTERED)). (Microsoft.SqlServer.ManagedDTS)” Cause: This error may indicate that you have serious problems with your Microsoft SQL Server 2005 installation, but as the error message says this error often is caused by a type library not is installed. (Not registered.) (dts.dll) Solution: Re-register the dts.dll file. On the server, open a command prompt and type: regsvr32 dts.dll This worked for me!! http://www.sqlservercentral.com/Forums/Topic204033-146-1.aspx ======================================== 1、打SP3补丁。(SP2补丁不知道行不行,我打的是SP3补丁); 2、打完SP3补丁后就出现上述错误:"Unable to cast COM object of type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass" 解决方法:重新注册dts.dll(regsvr32 dts.dll); 以上两步就OK了!
http://d:/我的文档/My%20Pictures/sql%20server%20操纵失败图/Database%20weihu
我把图片放在这儿:http://user.qzone.qq.com/975508300/infocenter?ptlang=2052
不知道能不能被看到了
========================================
1、打SP3补丁。(SP2补丁不知道行不行,我打的是SP3补丁);
2、打完SP3补丁后就出现上述错误:"Unable to cast COM object of type ‘Microsoft.SqlServer.Dts.Runtime.Wrapper.PackageNeutralClass"
解决方法:重新注册dts.dll(regsvr32 dts.dll);
以上两步就OK了!