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

Knowledge Measure

  1. In what format should you store a DTS package that you'd like to send via e-mail to a colleague?

  2. What single DTS component is the engine behind the Transform Data task, the Data Driven Query task, and the Parallel Data Pump task?

  3. True or false: You must define the package to be used in a transformable replication subscription using the DTS Designer and must use a Data Driven Query task to refer to published articles.

  4. What DTS task can you use to retrieve values from an INI file and assign them to global variables?

  5. True or false: Conditionally executing a given task line in a DTS package requires the use of an ActiveX Script task.

  6. What interface must a COM object implement in order to serve as a custom DTS task?

  7. Describe the function ...

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