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

Overview

Architecturally, DTS is composed of the following pieces:

  • OLE DB providers. (Technically speaking, these aren't part of DTS, but they are integral to using it. OLE DB is the means by which DTS retrieves and stores data.)

  • A multiphase data pump that you can use to set up sophisticated data transformations.

  • A graphical designer that is based on an extensible COM-based object model. The key elements in this model are packages and tasks. In order to serve as a custom DTS task, a COM component must implement the CustomTask interface defined in the Microsoft DTSPackage Object Library. This component must run in-process in order to be used in the DTS Designer, but it can run out-of-process when used programmatically.

  • A set of programmable COM ...

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