Dimensions
185 x 230 x 13mm
Advanced Level Users.
Includes CD-ROM.
A critical task in managing data these days is knowing how to import, export and transform it from one database to another, while allowing for seamless updating and reliable data integrity. This book shows how to use SQL Server Data Transformation Services (DTS) to accomplish this complex task.
The book begins by introducing DTS and describing its OLE DB based architecture, followed by a detailed example of how a DTS package operates, to provide context to the theoretical background.
Then the book covers DTS tools, package components and execution, scripting, logging, error handling, troubleshooting, security and other advanced topics, plus how to use the Microsoft Visual Basic development system with DTS.
The book also discusses DTS deployment strategies and it provides useful scenarios and practical examples to help anyone grasp the ins and outs of DTS.
