Description of Professional SQL Server 2000 DTS - Data Transformation Services
The Publisher writes:
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.
Professional SQL Server 2000 DTS follows on from Professional SQL Server 7.0 Programming to drill down into this important and powerful feature of SQL Server 2000. This book begins with a complete introduction to DTS fundamentals and architecture. Building on this introduction we'll take a look at more complex data transformations and security issues involved in moving data between different servers, applications and providers (eg Oracle, DB2, Sybase). The book then focuses on DTS via the DTS object model, which enables developers to incorporate custom transformations and reporting capabilities into their applications. We use examples in both Visual Basic and scripting languages. More advanced topics are then explained including error handling, dynamic data loading, OLAP and Datawarehouses. With code and case studies this book provides a thorough guide to this new upcoming area of SQL Server 2000.
Table of Contents:
Introduction
Chapter 1: Welcome to DTS
Chapter 2: DTS Fundamentals
Chapter 3: Advanced Tasks
Chapter 4: Advanced Settings in DTS
Chapter 5: Querying Heterogeneous Data
Chapter 6: Converting Heterogeneous Data
Chapter 7: ActiveX Script Task Fundamentals
Chapter 8: Dynamic Configuration of Package Objects
Chapter 9: Advanced ActiveX Scripting
Chapter 10: Security and DTS
Chapter 11: Error Handling
Chapter 12: Writing Your Own Custom Tasks
Chapter 13: Data Warehouse Loading
Chapter 14: Using DTS from Other Applications
Chapter 15: Warehouse Data Load
Appendix A: Microsoft Data Transformation Services Package Object Library Reference
Appendix B: ADO Object Summary
Appendix C: Visual Basic Functions and Keywords
Appendix D: Variable Naming and Other Code Conventions
Appendix E: Microsoft Scripting Run Time Reference
Title Information
- ISBN:
- 9781861004413
- Pages:
- 830 pages
- Format:
- Paperback
- Product Code:
- 156704
- Publisher:
- Wrox Press
- Published:
- 30/09/2000
Write a review of this book
Customer Reviews from Amazon
Shopping basket
