This book appeals to both developers and database
administrators who are faced with the common situation of
having to migrate or integrate
data from one location into
another. While the first
section of the book is designed
for the beginner to
DTS, it is assumed that the reader has
at least
basic database and programming experience. The
second section is extensive coding, and is best used by
someone with intermediate to advanced programming skills.
The third section contains a mix of examples that will be
useful to all levels of database administrators and
programmers. For the readers who have been
using DTS this
section can be used as a reference section and help with
DTS designs and usage. Unlike other resources available,
this book covers data transformation in both
SQL Server 7
and 2000.
Contents
Data transformation services -
the tool
- DTS in the ETL world
- DTS - an overview
- Connections
- DTS tasks
- More DTS tasks
- DTS workflows
- Package
- Putting it all together - an extyented DTS example
Automating data transformation services
- Building a package using visual basic
- Interacting with a package using virtual basic
DTS and the business intelligence process
- Introduction to data warehousing and analysis
services
- Building a datawarehouse with DTS and analysis
services
- DTS and data mining
Using the tool - Case studies
- Custom error logging with DTS
- Managing distributed databases with DTS and messages
queues
- Creating a DTS package from a stored procedure
- Data lineage