O'Reilly logo

SQL Server DTS by Steve Hughes,, Steve Miller,, Marcelino Santos,, Brian Sullivan, Jim Samuelson,

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required