Oct
28
2011

SQL Server 2005 Maintenance plan error: Unable to cast COM object

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 present, by default it is available at C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll , but it may vary based on your installation location, for me it was located on some other drive due to some standard drive structure,
2. execute following on cmd prompt: regsvr32 “< path of dts.dll >”
For e.g. regsvr32 “C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTS.dll”

3. You will recieve following success message,

It fixed the maintenance plan problems for me – I have SQL Server 2005 Standard SP1 running. This solution is applicable for SQL Server 2005 SP2 and SP3 as well and for 64 bit version you need to go to (x86) folder and register dts.dll

Download PDF

Related Posts

About the Author: Nitin Garg

Indian born, trekker, biker, photographer, lover of monsoons... I love to blog the topics I research and find useful for self or online community to save time and energy :) Everything you read on my blog is my own personal opinion!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 174 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

May 2019
M T W T F S S
« Nov    
 12345
6789101112
13141516171819
20212223242526
2728293031  

View Post by Categories

%d bloggers like this: