I downloaded the sample code from Wrox and tried to open the
ETL_Step1.dts file I unzipped from the SQL Server 2000 Enterprise Manager DTS Service node. However, it returns me with the following error msg:

Error Source: Microsoft Data Tranformation Services (DTS) Package
Error Description: Invalid class string

I tried all 4 DTS package files and they all fialed with the same error msg. Has any one encountered the same problem?

Hey,

Can you track it to a specific component or piece of code for this? I don't have the book, so I can't help you out further. If you have any code or settings, that would be great.

Brian

Hello Brian:

I am not sure how to run the test you mention above. In lieu of this, please download any of the ETL Steps from this link:

http://www.wrox.com/WileyCDA/WroxTit...load_code.html

And see if you get the same error.

TIA.

Regards..

Yes we get the same error.

I am getting same error. Any ideas from anyone or the publisher?

Try running the pieces manually individually (right-click each step, click run). See which step causes the error...

Brian

I downloaded the sample code from Wrox and tried to open the
ETL_Step1.dts file I unzipped from the SQL Server 2000 Enterprise Manager DTS Service node. However, it returns me with the following error msg:

Error Source: Microsoft Data Tranformation Services (DTS) Package
Error Description: Invalid class string

Has anyone able to open the package?

Please refer to:

http://support.microsoft.com/?scid=k...8910&x=15&y=16

I think you (and I...) have to write the Error Handler task by hand and register it in SQL Server before opening the package.

Regards,
Stelvio

Hello I know I'm late by almost 2 years. But let me list the steps that I followed. Thanks for the clue Stelvio!!!

Assuming that you have only MSSQL Server 2000, the first thing do to would be to
create a new database by name NorthwindDW.

Next, Install the Analysis Services. This will install without any fuss even if you have SQL Server 2000 "Personal Edition".

From Analysis Services, connect to your local database server.
Once connected, right-click and then select "Restore Database".
Select the CAB file that you've downloaded and you'll be on your way to restoring it without any problems.
Like me, if you have an egg beater for a desktop (more than 2 years old that is) then a little patience will come in handy before the restoration is complete.


To restore DTS Packages, I would download DTSBackup 2000 (Google this to download).

Try re-importing the packages, and now the error "Invalid Class String" would've graduated to become "System cannot find the file specified".

This leaves us with one more thing that you need to do before you restore all these packages. If you read the chapter on Datawarehousing, you'll see that these packages need to have the NorthwindDW database and certain physical paths pre-existing with all the UDL files in place. Create the paths as specified in the book, and change the connection strings to apply to your machine and try re-importing again. You must be all set.

Cheers!!!
-Shanthanu

HELP! HELP! HELP!
I still get the same Invalid class string error when I try to just load the 'ETL_Step1.dts' file(s)....
I have the NorthWind_DW restored...
I have the 'C:\DTS2k_CS' dir created -- just like in the book.
I have the 'udl' files created and working to point to the correct databases.
I tried using DTS Backup 2000 to load the DTS files....
Still I get the error...
What is missing that I need to have setup on my machine to load the DTS files from the download.
Do I need a registered DLL from one of the the previous chapters?