Chapter 5: Working with Advanced DTS Options

Overview

In this chapter, you will learn how to:

• Configure package and task execution properties

• Enable transactions and join packages and tasks into existing transactions

• Enable and configure exception files

DTS provides a number of advanced options that enable you to control the execution of tasks and packages and enhance their functionality. These options include the ability to configure execution priorities, the number of tasks that execute in parallel, definitions of packages, properties of transactions, and exception files. For example, you can design a modularized data movement application with many packages that can execute in parallel. You can then adjust the number of packages that actually execute in parallel based on the capabilities of the production computer on which the data movement application is deployed. You might also want to increase the execution priority of the entire data movement application when it is being executed on a multi-processor computer, or increase the execution priority of a particular task or package within the data movement application.

To design your data movement application to take advantage of the advanced options, and to ensure the proper functionality of tasks and packages, you must understand the consequences of using the options and know where their use is required.