Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > BOOK: Professional SQL Server 2000 DTS
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2000 DTS
This is the forum to discuss the Wrox book Professional SQL Server 2000 DTS (Data Transformation Services) by Mark Chaffin, Brian Knight, Todd Robinson; ISBN: 9780764543685
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2000 DTS section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old August 23rd, 2004, 07:39 PM
Registered User
 
Join Date: Aug 2004
Location: , , .
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default Erro in openning ETL_Step1.dts

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?

Reply With Quote
  #2 (permalink)  
Old August 24th, 2004, 07:23 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

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
Reply With Quote
  #3 (permalink)  
Old September 13th, 2004, 02:33 PM
Registered User
 
Join Date: Sep 2004
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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..

Reply With Quote
  #4 (permalink)  
Old March 4th, 2005, 10:53 AM
dts dts is offline
Registered User
 
Join Date: Mar 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Yes we get the same error.

Reply With Quote
  #5 (permalink)  
Old May 24th, 2005, 09:35 PM
Registered User
 
Join Date: May 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
  #6 (permalink)  
Old May 31st, 2005, 08:37 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: Harrisburg, PA, USA.
Posts: 1,998
Thanks: 0
Thanked 3 Times in 3 Posts
Default

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

Brian
Reply With Quote
  #7 (permalink)  
Old September 20th, 2005, 10:31 AM
Registered User
 
Join Date: Sep 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?


Reply With Quote
  #8 (permalink)  
Old October 6th, 2005, 12:26 PM
Registered User
 
Join Date: Oct 2005
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

Reply With Quote
  #9 (permalink)  
Old February 24th, 2007, 02:23 PM
Registered User
 
Join Date: Feb 2007
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #10 (permalink)  
Old July 24th, 2007, 06:19 PM
Registered User
 
Join Date: Mar 2005
Location: , , .
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?


Quote:
quote:Originally posted by andymenon
 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
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Openning remote web sites for development rodmcleay VS.NET 2002/2003 5 March 13th, 2007 02:12 PM
Error when openning solution p101 BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 3 June 30th, 2006 08:04 AM
Default the new record in a table while openning anukagni Access 5 January 9th, 2006 05:21 AM
Openning a PDF file mcinar Classic ASP Basics 5 February 11th, 2005 10:49 PM
problem openning huge xls file helmekki Excel VBA 3 October 5th, 2004 04:43 AM



All times are GMT -4. The time now is 06:23 AM.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.