Today while fixing SQL 2005 SP2 (9.00.3042) maintenance plan issues, came across three errors, first error is due to dts dll not registered properly, whereas second one is occuring when trying to create/edit schedule or creating a maintenance plan thorugh Wizard mode. Read below to understand the issue and how it is fixed. 1. While trying to open maintenance plan, recieved following error, To fix this error, I have used the technique which I have […]

Today while configuring maintenance plan on one of SQLServer 2005 SP1, I recieved 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)” Resolution was pretty straight, found at following fourm link Resolution: 1. Find the path where DTS.dll is […]