Professional SQL Server 2000 DTS (Data Transformation Services)
By Mark Chaffin, Brian Knight, Todd Robinson
Publisher: Wiley / Wrox
Final Release Date: August 2004
Pages: 888

DTS (Data Transformation Services) helps you create a transactionalsystem to load and transform your data from and to a wide varietyof sources. SQL Server DTS was introduced in the release of SQLServer 7.0; SQL Server 2000 sees the functionality and power ofthis outstanding and incredibly useful tool greatly increased. DTScan be used to maximum effect in data-driven applications, offeringrapid and effective solutions to a 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.

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.

What does this book cover?

  • 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
Product Details
Recommended for You
Customer Reviews
Buy 2 Get 1 Free Free Shipping Guarantee
Buying Options
Immediate Access - Go Digital what's this?
Ebook: $49.99
Formats:  PDF