Chapter 1. DTS in the ETL World

DTS in the ETL World

When we first heard Of SQL Server’s Data Transformation Services (DTS), it was described as the perfect tool for loading data into a data warehouse, which is a task for which it seemed to be well suited. The first time we had an opportunity to use DTS, however, came from the need to translate data from an old application to a dramatically improved re-architecture. Our second experience involved processing Microsoft Exchange log files to perform analysis on email traffic across an entire multinational corporation. Although DTS was the best solution for that project, it still was not a data warehouse (but it would ...

Get SQL Server DTS now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.