Microsoft SQL Server 2000 Data Transformation Services covers all facets in the development of data transformations with DTS. The reader will learn how to create each of the DTS tasks, both in the User Interface supplied with SQL Server and through the object model using Visual Basic or VBScript. Microsoft SQL Server 2000 Data Transformation Services is filled with numerous small examples, showing how each of the capabilities of DTS can be used. It also includes a number of Data Transformation Templates, which can be used by the readers to help develop their own packages.Timothy Peterson. Chapter 4 Loading Data into a Staging Area A staging area is a set of tables that are used to store data temporarily during a data load. Staging areas are especially useful if the source data is spread out over diverse sources.
|Title||:||Microsoft SQL Server 2000 Data Transformation Services|
|Publisher||:||Sams Publishing - 2000-12-01|