DTS Developer's Guide
Published on 1. November 2000
Book
Paperback/Softback
608 pages
978-0-07-212411-8 (ISBN)
Description
This guide is designed to provide information to programmers using and developing SQL server data transformation services. It gives an overview of the history and architecture of DTS, use of DTS's graphical interface and examines the configeration management issues with DTS projects.
More details
Series
Language
English
Place of publication
New York
United States
Publishing group
McGraw-Hill Education - Europe
Target group
College/higher education
Professional and scholarly
Illustrations
30 illustrations
Dimensions
Height: 235 mm
Width: 191 mm
ISBN-13
978-0-07-212411-8 (9780072124118)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Classification
Content
Part 1 Overview of DTS: evolution of data movement; DTS architecture; environment. Part 2 Using the package Designer: getting started; exploring the Designer; packages properties; managing connections; managing the transformation task; managing tasks; managing workflow; advanced topics; common transformation samples. Part 3 Leveraging the DTS object model: getting started; package objects; connection object; step object; custom task object; data pump; using the built-in tasks; building custom tasks; building customer transformations; building custom packages. Part 4 Configuration management: DTS and the Microsoft repository; deployment planning; maintainability. Appendices: using the import and export wizards; the Microsoft data warehousing framework; the DTS package constants; the DTS scripting constants.