Ebook: Professional SQL Server 2000 DTS (Data Transformation Service)

One of the new outstanding features of SQL Server is Data Transformation Services (DTS). DTS can be used by both developers and database administrators (DBAs) and is attracting a lot of interest. There is a demand for information and currently no other books are available to satisfy this. DTS enables data to be moved between a wide variety of sources and destinations, as well as transforming the data along the way to suit your requirements. DTS can be used to maximum effect in data-driven applications, enabling dynamic data transfer across internet and intranet applications. This offers rapid and effective solutions to common problems such as: Automatically transferring data into data warehouses Importing and exporting data to and from other applications for analysis and reporting Moving working copies of databases between servers The capabilities of DTS are large and this book will give the reader a complete picture of how to use DTS to its fullest potential.