×
![]( "Buchcover ISBN 9780764558566")
Professional SQL Server 2000 DTS (Data Transformation Services)
von Mark Chaffin, Brian Knight und Todd RobinsonWhat 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:
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.
(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:
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.