Options

DTS 15 - Invalid Class String when registering server

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited July 18, 2005 10:26AM in Knowledge Base
Date: 16 Sep 2004
Versions: DTS Compare 1.1-1.5

When registering a server in DTS Compare, you may recieve an error 'Invalid Class String', followed by a string of numbers and letters (a GUID). The reason for this is that there is an object type in the DTS Package that is not installed on the client computer running DTS Compare.

In most cases, there is a DTS package on the server that utilizes SQL Server Analysis Services data cubes.

If SQL Server Analysis Services is not installed on the computer running DTS Compare, it cannot make sense of the attributes of the data cube.

The solution is to install SQL Server Analysis Services from the SQL Server CD onto the computer that is running DTS Compare. This will register the necessary classes to allow DTS Compare to get information about the data cube in the DTS Package.

Comments

  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    If you have written a custom task in Visual Basic, you will also get this same error unless the .dll file containing the custom task is also installed and registered on the workstation running the DTS Compare software.
Sign In or Register to comment.