O'Reilly logo

Guru's Guide to SQL Server Architecture and Internals, The by Ken Henderson

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

Recap

DTS is a welcome and powerful addition to the SQL Server technology family. It provides a wealth of data transformation and workflow management facilities that rival those in third-party products. In many ways, DTS is a self-contained visual programming environment—you can use it to build lots of different types of applications, even those not directly related to transforming data.

The primary means of data transport within a DTS package is the multiphase data pump. This component allows data to be moved from one OLE DB provider to another. It's the engine behind the Transform Data task, the Data Driven Query task, and the Parallel Data Pump task. You can also use Bulk Insert tasks to move data from a text file into SQL Server. DTS provides ...

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