Professional SQL Server 2000 DTS (Data Transformation Services)
Buch in deiner Nähe kaufen
Beschreibung
What is this book about?
(DTS) Data Transformation Services helps you create atransactional system to load and transform your data from and to awide variety of sources. SQL Server DTS was introduced in therelease of SQL Server 7.0; however, SQL Server 2000 sees thefunctionality and power of this outstanding and incredibly usefultool greatly increased. DTS can be used to maximum effect indata-driven applications, offering rapid and effective solutions toa wide range of common problems.
Professional SQL Server 2000 DTS provides a completeintroduction to DTS fundamentals and architecture before exploringthe more complex data transformations involved in moving databetween different servers, applications, and providers. The bookthen focuses on DTS programming via the DTS object model, enablingdevelopers to incorporate custom transformations and reportingcapabilities into their applications. Advanced topics are explainedincluding error handling, dynamic data loading, and datawarehouses. With code and case studies, this book gives the readera complete picture of how to use DTS to its fullest potential.
What does this book cover?
Here are just a few of the things you'll find covered in thisbook:
* A detailed explanation of the seventeen principal DTStasks
* Connecting to, querying, and converting heterogeneous data
* Dynamic configuration of your DTS packages
* Enhancing your DTS packages with VBScript and Visual Basic
* Writing your own custom tasks
* Using DTS in a data-warehousing environment
* Employing DTS in other applications
Who is this book for?
This book is principally aimed at database programmers andadministrators who have a working knowledge of SQL Server, and whowish to take DTS beyond its most basic level and tailor it to theirneeds. It will also appeal to managers and project managers whowant to gain an understanding of DTS and how it could benefit theirbusinesses.
Autor*in
Mark Chaffin
Themen in »Professional SQL Server 2000 DTS (Data Transformation Services)«
Computer Science Database & Data Warehousing Technologies Datenbanken u. Data Warehousing Informatik SQL Server 2000