Chapter 1. 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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
