Professional SQL Server 2000 DTS (Data Transformation Services)

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:

http://support.microsoft.com/support/kb/articles/Q288/9/10.ASP

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

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

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.

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