This book consists of ten chapters, organized as follows :
Chapter 1, Jumping into DTS, provides an introduction to the capabilities of DTS. In this chapter, you learn how to create DTS packages using the DTS Import/Export Wizard that import and export data from heterogeneous data sources. You also learn how to copy objects and data between SQL Server databases.
Chapter 2, Using DTS Designer to Build and Extend Packages, teaches you how to modify and extend existing DTS packages using DTS Designer. You learn how to work with connection objects and to work with the Transform Data, Execute SQL, and Bulk Insert tasks. You also learn how to add precedence constraints to package tasks to control their execution order.
Chapter 3, Working with DTS Packages, teaches you how to save DTS packages in different formats and to utilize version control. You also learn how to secure and execute DTS packages. Finally, you learn how to enable package execution logging and error logging.
Chapter 4, Creating Advanced DTS Tasks, teaches you how to perform lookup queries inside a Transform Data task and to use a Data Driven Query task to determine which of several queries to exe cute based on the content of the data in each row. You also learn how to access the phases of the multiphase data pump and to call a sub package using an Execute Package task.
Chapter 5, Working with Advanced DTS Options, teaches you how to configure package and task execution properties. You also learn how to enable transactions and join packages and tasks into existing transactions. Finally, you learn how to enable and configure exception files.
Chapter 6, Dynamically Configuring DTS Package Objects, teaches you how to use a data link connection to dynamically config ure the connection objects in a package. You also learn how to use the Dynamic Properties task to dynamically configure package and task objects at run time through the use of an initialization file and global variables . Finally, you also learn how to change the global variable values in a subpackage from a master package at run time.
Chapter 7, Using ActiveX Script Tasks, teaches you how to use ActiveX Script tasks to set global variable values in packages and tasks at run time from a SQL Server table and from the Windows registry. You also learn how to use ActiveX Script tasks to incorpo rate branching into your DTS packages.
Chapter 8, Incorporating Error Handling into DTS Packages, teaches you how to add batch control to a data movement applica tion. You also learn how to create step and package success and error logging tasks. Finally, you also learn to record information about the number of rows transformed and the number of rows with errors in an audit table in SQL Server.
Chapter 9, Completing the Data Movement Application, teaches you how to create a starter DTS package as a template for future packages. You then use this starter package to create the final pack age required to complete the data movement application. Finally, you learn how to restore an Analysis Services cube and then add an Anal ysis Services Processing task to a package, which updates the data in the Analysis Services cube.
Chapter 10, Operating the Data Movement Application, teaches you how to use the data movement application. You learn how to modify the initialization file and configurations of global variable values in a SQL Server table to control the operation of the data movement application. You also learn how to use an audit table in SQL Server and the batch capabilities of the data movement applica tion to easily understand the results of each execution of the data movement application.