Chapter 5: Working with Advanced DTS Options


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.

Microsoft SQL Server 2000 DTS Step by Step
Microsoft SQL Server 2000 DTS Step by Step (Step by Step (Microsoft))
ISBN: 0735619166
EAN: 2147483647
Year: 2003
Pages: 87
Authors: Carl Rabeler

Similar book on Amazon © 2008-2017.
If you may any questions please contact us: