Wrox Home  

Topic: SQL Server

Professional SQL Server 2000 DTS (Data Transformation Services) (0764543687) cover image

Professional SQL Server 2000 DTS (Data Transformation Services)

Mark Chaffin, Brian Knight, Todd Robinson
ISBN: 978-0-7645-4368-5
888 pages
July 2000
This title is out-of-print and not currently available for purchase from this site.

Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
0 Problems with Case Study files

A problem occurs when opening the ETL packages forming part of the case study; the system throws up the following error:

Error source : Microsoft Data Transformation service (DTS) package
Error description: Invalid class String

More information can be found at:


Readers are advised to build up the case study packages on their own machine.

18-May-01 1
50 Incorrect grammar

At the end of the first bullet point in the section entitled 'Transform Data Task' there are two minor errors ??? the sentence should read 'Unfortunately, DTS is not intelligent enough to know that if you have a column with a character value, it can't be mapped to a column with an integer value.'

09-May-01 1
96 IMPORTANT: misleading information

It has come to our attention that the paragraph directly underneath the title 'DTS Interoperability' is misleading. In this paragraph, we stated that '...you do not need SQL Server to run DTS'. This information is not entirely true ??? readers are referred to the file 'redist.txt' found on the root of the SQL Server installation CD for more information.

Furthermore, official sources state the following: 'While from an architectural and technical implementation perspective DTS is independent from SQL Server, from a licensing perspective, DTS (as well as any of the other redistributable components packaged with SQL Server) must be part of an application that works in conjunction with SQL Server. While this means that SQL Server must be one of the components in your application, it doesn???t mean that your DTS components need to be run from the same physical machine.'

We apologise for any confusion that this statement may have caused and ask readers to disregard this paragraph.

09-May-01 1
551 Wrong name in explanation

In the section entitled 'DIM_EMPLOYEE' the explanation states that an index will be created on 'direct_report_nk'. This should read 'direct_report_wk'.

09-May-01 1
Printer-Ready Version   Share This
With you wherever you go: pdf + ePub + kindle -- DRM-free