Hi,

I am running into the "Invalid Class String" error whenever I tried to open the etl1, 2 or 3 package that I downladed from the wrox site for the book Professional SQl Server 2000 DTS. Has anyone experienced this problem before? Any help in this regard is greatly appreciated.

Thanks,
Josh

I too received the same error "Invalid Class String", whenever i try to open the ETL_1.dts and other..

Any help on this issue is greatly appreciated

Thanks
Murali

I also get the Invalid Class string when trying to open any of the ETL packages (1-4). I would love it if there was some help or an update.


Regards,

John Wright
E-Commerce Architect

The errata section of this book guggests going to
http://support.microsoft.com/default...NoWebContent=1
for fixes on the "Invalid class string" problem. However, according to the page, it suggests one of the following 4 workarounds:

*********************************************
The 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:
1. 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.asp

2. If 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.
3. 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.
4. If your package contains custom DTS tasks, you must register these tasks on the workstation in question.
***************************************

I think (4) might be the answer. But, how do you register these DTS tasks?