Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Crespo24
Village Idiot
144 Posts |
 Posted - 2003-01-23 : 06:22:46
|
Hi guys,Just been upgraded to XP and my SQL-Server is screwed up. I was using the DTS to populate a set of tables, but the package can not be open now thanks to XP. Anyway, I decided to create the package again, but when I click on the transformations TAB I get the following error message, 'Invalid class string'.What the hell is going on?!Thanks in advance. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-23 : 06:28:23
|
| Have you tried reinstalling sql server?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Crespo24
Village Idiot
144 Posts |
Posted - 2003-01-23 : 06:35:05
|
quote:
Have you tried reinstalling sql server?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy.
Well, the PC Support team gave me a whole new machine (how nice of them!) so I don't know what's going on! |
|
|
|
SteveR74
Starting Member
6 Posts |
Posted - 2003-01-28 : 10:49:13
|
| Hello Everyone,I am having the exact same problems as Crespo24, whats going on?.I do not have the option of reverting back to Windows 2000 and I have a lot of work stuck in DTS Packages that I cannot open.Does the 2000 client install differ from the XP client install? (The machine is new with a fresh SQL Server install).any ideas?This item from technet is the only reference to 'Invalid Class String' that I can find, and I am not even sure it relates to my problem.PRB: "Invalid Class String" Error When Opening DTS PackageThe information in this article applies to:Microsoft SQL Server 2000 (all editions)Microsoft SQL Server 7.0This article was previously published under Q288910 SYMPTOMSWhen you attempt to open a Data Transformation Services (DTS) package in the Enterprise Manager DTS Designer, the following error message may be displayed: Error Source: Microsoft Data Transformation Services (DTS) PackageError Description: Invalid class string. If you attempt to open the package in SQL Server 2000, the following error message may also be displayed: The selected package cannot be opened. The DTS Designer has been closed. CAUSEThis error message occurs when the class identifier for a DTS task has not been registered properly with Windows. Because DTS tasks are registered with Windows using a COM class ID (CLSID), if that identifier is not present, a package that includes these unregistered tasks will not open. This error may occur in the following situations (note that this is not an exhaustive list): A package includes Microsoft OLAP Services or Analysis Services tasks (such as the Data Mining Prediction task or Analysis Services Processing task) but the workstation on which a user attempts to open the package does not have either the OLAP or Analysis Services management tools, or the DTS Task Kit installed.A package includes new SQL Server 2000 tasks (such as the Execute Package task or the Dynamic Properties task) and a user attempts to open that package with the SQL Server 7.0 management tools.A package includes a user-designed custom DTS task but the workstation on which the package is opened does not have this task registered.WORKAROUNDThe solution to this problem depends on the type of tasks that are present in the DTS package. Because these tasks (and their associated class IDs) must be registered with the operating system, this problem is usually alleviated by an installation of the components in question: If the package includes an OLAP Processing task from a SQL Server 7.0 server, you can install the DTS Task Kit from the following Microsoft Web site:http://www.microsoft.com/sql/downloads/DTSKit.htmIf the package includes other tasks shipped with Microsoft SQL Server 2000 Analysis Services, you must install the Analysis Manager component that is available during SQL Server 2000 Analysis Services setup.In the case of tasks newly shipped with SQL Server 2000, you must install the SQL Server 2000 Client Tools on the workstation in question.If your package contains custom DTS tasks, you must register these tasks on the workstation in question.Thanks,Steve |
|
|
|
SteveR74
Starting Member
6 Posts |
Posted - 2003-02-05 : 07:33:51
|
| Bounce |
|
|
|
|
|
|
|
|
XP upgrade causes error message