Microsoft® SQL Server™ 2000 DTS Step by Step

Microsoft® SQL Server™ 2000 DTS Step by Step
Published:August 27, 2003Language:English
Author:Carl RabelerTechnology:Microsoft SQL Server 2000
Length:464 PagesISBN 13:9780735619166

List Price:

$ 39.99
About The BookYour step-by-step guide to capturing and transforming data from across the enterprise—and beyond.

Teach yourself how to use SQL Server 2000 Data Transformation Services (DTS)—and begin writing your own data movement applications—one step at a time. This practical, hands-on tutorial expertly guides you through the development of a DTS application that extracts and transforms data from a database into a data warehouse. Work at your own pace through the easy-to-follow lessons and hands-on exercises to master essential techniques. And accelerate your productivity by working with instructive code examples and best practices for SQL Server 2000 DTS.Discover how to:
  • Create simple data movement packages with the DTS Import/Export Wizard
  • Create a complex data movement application with the DTS Designer that configures pre-built DTS tasks
  • Exploit the flexibility of the Data Driven Query (DDQ) task without sacrificing performance
  • Incorporate execution logic, flow control, branching, transaction control, and parallel execution into DTS packages and tasks
  • Dynamically configure DTS packages and tasks at run time
  • Save DTS packages in SQL Server, Meta Data Services, Structured Storage, and Microsoft Visual Basic® file formats
  • Extract and transform heterogeneous data using ActiveX® Scripts
  • Integrate customized logging, error handling, and batch control into your application
  • Deploy and operate a data movement applicationAbout DTS in SQL Server 2000Microsoft SQL Server 2000 Data Transformation Services (DTS) provides a set of graphical tools and programmable objects to extract, transform, and consolidate data from disparate sources into single or multiple destinations. By using DTS tools, you can create custom data movement solutions to support decision-making, improve system performance, upgrade existing systems, and more. CD features:
  • Practice files for all the book’s procedures
  • About Carl RabelerCarl Rabeler is an MCT, MCDBA, and MCSE. In conjunction with the Business Intelligence Practices group at Microsoft, Carl authored the technical documentation for the SQL Server Accelerator for Business Intelligence, the DTS Programming Practices Used in SQL Server Accelerator for Business Intelligence white paper, and the Microsoft Analysis Services Performance Guide white paper. Carl also wrote the SQL Server High Availability Series, which is available via MSDN. He also wrote the Microsoft SQL Server 2000 System Administration MCSE Training Kit and the Academic Learning Series course based on that book. Before that, he was a subject matter expert for the Microsoft Official Courseware group from 1995 through 2000, working with both Microsoft SQL Server and Microsoft Exchange Server. Carl has also been an independent software consultant since 1989, developing hardware and software solutions for a variety of customers.
    Looking for training resources, events and advice from peers? Join the Microsoft Training and Certification Community. Preparing for an exam now? Find your Microsoft Certification Study Group. Talk to us on these social networks:
    What do you think of this book? Your feedback is important in helping us create books that serve your needs and meet your expectations.Please take our survey at

    Note: You will need this book's 13-digit International Standard Book Number (ISBN) to take the survey.The ISBN 13 can be found above.
    To report or search for corrections in this book or its companion content,
    search for the title in our online store and then check the Errata & Updates tab. To report errors, please go to our Submit errata page.