Index_O

O

object names

enclosing in quotation marks in the generated script, Copying Objects and Data Using the DTS Import/Export Wizard

objects

copying, Chapter 1: Jumping into DTS

resizing on the design sheet, Connection Objects

ODBC data source

extracting or copying data from, Importing Data Using the DTS Import/Export Wizard

support for joining transactions, Enlisting Tasks in Transactions

OLE DB data source

configuring a UDL file to connect to, Using Data Link Connection Objects

extracting or copying data from, Importing Data Using the DTS Import/Export Wizard

OLE DB Provider for SQL Server

support for joining transactions, Enlisting Tasks in Transactions

OLE DB scanner

accessing, Saving Packages

OLEDBCommand object

generated by a Bulk Insert task, Important

On Batch Complete phase

of the multiphase data pump, Accessing the Multiphase Data Pump

On Completion precedence constraint, Precedence Constraints

activating, Using Parameterized Queries in a Data Driven Query Task

changing an On Success precedence constraint to, Precedence Constraints

deleting, Precedence Constraints

in the SQL_DTS_SBS_1.1 package, Precedence Constraints

selecting, Creating Logging Steps in the MasterUpdate Package, Creating Logging Steps in the UpdateCustomerDim Package

On Failure constraints

using to define actions for step failures, Enabling Package Logging

On Failure precedence constraint, Precedence Constraints

On Pump Complete phase

of the multiphase data pump, Accessing the Multiphase Data Pump

On Success precedence constraint, Precedence Constraints

changing to an On Completion precedence constraint, Precedence Constraints

creating, Precedence Constraints

deleting, Precedence Constraints, Change the task flow to parallel

in the SQL_DTS_SBS_1.1 package, Precedence Constraints

On Success precedence constraints

creating, Creating a Data Load Package in DTS Designer

operating data movement applications

adding missing dimensions and rows, Loading and Verifying Monthly Data

adding Time dimension members , Loading Historical Data

AuditEvents table, reviewing, Loading Historical Data

browsing the Sales cube, Loading Historical Data, Loading and Verifying Monthly Data

config.ini, modifying, Loading and Verifying Monthly Data

LoadHistoricalData package, configuring, Loading Historical Data

loading historical data, Loading Historical Data

loading monthly data, Loading and Verifying Monthly Data

MasterUpdate package, executing, Loading Historical Data, Loading and Verifying Monthly Data

overview, Chapter 10: Operating the Data Movement Application

processing the Sales cube, Loading Historical Data

resetting the database, Resetting the Data Movement Application in the SBS_OLAP Database

Time dimension members, adding, Loading and Verifying Monthly Data

UpdateSalesFacts package, configuring, Loading and Verifying Monthly Data

operating system thread

configuring the execution priority of, Configuring Execution Priority

operators

selecting in Query Builder, Importing Data Using the DTS Import/Export Wizard

out-of-order task execution, Precedence Constraints

outer package global variable

specifying giConfigID as, Passing the giConfigID Value to Subpackages and Dynamically Configuring the Execute Package Tasks in the MasterUpdate ...

outer package global variables , Important, Dynamically Changing Global Variable Values in Another Package

configuring, Dynamically Changing Global Variable Values in Another Package

Outer Package Global Variables tab, Dynamically Changing Global Variable Values in Another Package

of the Execute Package Task Properties dialog box, Calling Subpackages

owner password

for a package, Connection Objects

securing DTS packages, Securing Packages Using Passwords