August 15, 2008 at 9:48 am
We are on SQL Server 2005 SP2 build 3161. When we try to veiw maintenance plans on the server we get the following message:
Unable to cast COM object of type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.ApplicationClass'
to interface type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSApplication90'.
This operation failed because the QueryInterface call on the COM component for the interface
with IID '{7591CC39-276A-4973-97C7-4EFEA5A5788F}' failed due to the following error: No such interface supported
When we try to execute the job for the maintenance plan, we get the error:
Executed as user: MIFSUATKNDB\SQLAgentService. Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 8:15:00 PM Warning: 2008-08-14 20:15:02.39 Code: 0x80012017 Source: Backup Databases Description: The package path referenced an object that cannot be found: "\Package\User Databases.Disable". This occurs when an attempt is made to resolve a package path to an object that cannot be found. End Warning DTExec: Could not set \Package\User Databases.Disable value to false. Started: 8:15:00 PM Finished: 8:15:02 PM Elapsed: 1.906 seconds. The package execution failed. The step failed.
This is only occurring on one server out of twelve. Does anyone have an idea of what is happening?
August 15, 2008 at 12:13 pm
Description: The package path referenced an object that cannot be found:
I would like to check what object could not be found if I were you.
August 15, 2008 at 12:57 pm
Verify that the client tools have been upgraded to at least the same version as the server you are connecting to. My guess is that your client tools have not been upgraded.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 15, 2008 at 1:07 pm
I don't know why this happened, but we ran regserv32 against the dts.dll and the problem went away. This server, and others in this domain, has been running for a while with no problems. Thanks for the suggestions
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply