Wrox Programmer Forums
|
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 software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 25th, 2004, 06:53 AM
Registered User
 
Join Date: May 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default CH 15 Code

I would like to follow Chapter 15 Warehouse Data Load without manually building the backend but am not sure what to do with the download code. Specifically I am not familiar with .dim_, .dimcr_, .dimtree_ and .dimprop_ files and how to use them. I thought the download files would be sql scripts and the like. Thanks

 
Old May 27th, 2004, 09:21 AM
Registered User
 
Join Date: May 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

got it

 
Old June 10th, 2004, 07:50 PM
Registered User
 
Join Date: Jun 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Is there a text version of the code on page 593 through 595?
So I can recomplie the source?
Thanks.
 
Old August 24th, 2004, 12:44 PM
Registered User
 
Join Date: Aug 2004
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default

When you download the Northwind DW file, make sure that you don't further unzip the embedded cab file "4419NorthwindDW.CAB" from downloaded zip file. After you extract the 4419NorthwindDW.CAB file, use Microsoft Analsis Services to restore the Northwind DW from the 4419NorthwindDW.CAB file. However, the problem I have with Chap 15 is the lack of downloadable source tables SQL DDL used by the Northwind DW example in Analysis Services. Furthermore, I also encountered problems with openning all 4 DTS packages.
Quote:
quote:Originally posted by DrBob
 I would like to follow Chapter 15 Warehouse Data Load without manually building the backend but am not sure what to do with the download code. Specifically I am not familiar with .dim_, .dimcr_, .dimtree_ and .dimprop_ files and how to use them. I thought the download files would be sql scripts and the like. Thanks






Similar Threads
Thread Thread Starter Forum Replies Last Post
Ch 15 - Security aspcoder BOOK: Beginning ASP.NET 3.5 : in C# and VB BOOK ISBN: 978-0-470-18759-3 7 May 3rd, 2008 02:55 PM
Ch. 15 Add'l Code? gekkster99999 BOOK: Beginning ASP 3.0 0 February 1st, 2004 10:55 PM
CH.15 NEED HELP stacy BOOK: Beginning ASP 3.0 1 January 21st, 2004 03:37 AM
Professional C# Second Edition Ch 15 Mike Smith BOOK: Professional C#, 2nd and 3rd Editions 0 January 5th, 2004 09:45 AM
Ch 15 login.asp code sirandre007 BOOK: Beginning ASP 3.0 1 January 3rd, 2004 07:11 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.