Index_A

A

Access connection objects, Connection Objects

AccessPubsDB database

connecting to, Importing Data Using the DTS Import/Export Wizard

shared connections to, Connection Objects

ActiveX Script task, Chapter 4: Creating Advanced DTS Tasks

adding a bypass load dimension table step to UpdateProductDim, Adding Branching Steps to UpdateProductDim Package

adding a bypass package step to UpdateCustomerDim, Adding Branching Steps to the UpdateCustomerDim Package

adding a bypass package step to UpdateProductDim, Adding Branching Steps to UpdateProductDim Package

adding a delete or add staging data branching step to UpdateCustomerDim, Adding Branching Steps to the UpdateCustomerDim Package

adding a delete or add staging data branching step to UpdateProductDim, Adding Branching Steps to UpdateProductDim Package

adding to record rows completed and rows with errors by the Load ProductStage Tablestep in UpdatePr, Reporting Row Processing Information by UpdateProductDim Package Tasks

creating to add a bypass load dimension table step to UpdateCustomerDim, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

creating to set global variables in the UpdateCustomerDim package, Updating Global Variable Values in the UpdateCustomerDim Package from the Configuration Table

creating to update the MasterUpdate package, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

joining transactions not allowed for, Enlisting Tasks in Transactions

reading the ConfigFile registry key value into MasterUpdate, Updating the Dynamic Properties Task in the MasterUpdate Package with a Registry Key Value

reading the ConfigFile registry key value into UpdateCustomerDim, Updating the Dynamic Properties Task in the UpdateCustomerDim Package with a Registry Key Value

reading the ConfigFile registry key value into UpdateProductDim, Updating the Dynamic Properties Task in the UpdateProductDim Package with a Registry Key Value

recording rows completed and rows with errors by the Insert Or Update ProductDim Table step of Upda, Reporting Row Processing Information by UpdateProductDim Package Tasks

recording rows completed and rows with errors by the Load CustomerStage Table step in UpdateCustome, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

setting global variable values in the UpdateProductDim package, Updating Global Variable Values in the UpdateProductDim Package from the Configuration Table

setting INI file location from the global variable value in MasterUpdate, Updating the Dynamic Properties Task in the MasterUpdate Package with a Registry Key Value

setting the INI file location, Updating the Dynamic Properties Task in the UpdateCustomerDim Package with a Registry Key Value

setting the INI file location in UpdateProductDim, Updating the Dynamic Properties Task in the UpdateProductDim Package with a Registry Key Value

transaction checkpointing for multiple transactions, Use Transaction Checkpointing for Multiple Transactions

ActiveX Script tasks

adding functionality to packages, Chapter 7: Using ActiveX Script Tasks, Creating Delete Configurations to Execute the Branches in the Subpackages

ActiveX script transformation

creating, Performing Lookup Queries in a Transform Data Task

ActiveX scripting task

Row Transform phase available through, Accessing the Multiphase Data Pump

ActiveX scripts

accessing data pump phases, Accessing the Multiphase Data Pump

leaving changed objects without context, Chapter 7: Using ActiveX Script Tasks

placeholder tasks, Calling the UpdateSalesFacts Subpackage from the MasterUpdate Package, Calling the UpdateSalesFacts Subpackage from the MasterUpdate Package

ActiveX transformation script

determining query execution, Using Parameterized Queries in a Data Driven Query Task

AddColumnsToAuditEventsTable.sql script, Modifying the AuditEvents Table to Record Row Processing Information

AddColumnsToDimTables.sql script, Modifying SQL Server Objects to Support Batch Control

AddColumnsToSalesFactTable.sql script, Saving Packages

AddInsertOrUpdateColumn.sql script, Using Parameterized Queries in a Data Driven Query Task

AddTablesToSBS_OLAP.sql script, Creating a New Package in DTS Designer

Advanced Copy Options dialog box, Copying Objects and Data Using the DTS Import/Export Wizard

Advanced DTS Run dialog box

displaying, Executing Packages

ALTER TABLE statement

dropping foreign key constraints on a table, Creating a Data Load Package in DTS Designer

AlterCustomerDimValues.sql script, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

AlterProductStageRowsetSP.sql script, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package

Always Read Properties From UDL File check box

selecting, Using Data Link Connection Objects

verifying the selection of, Using Data Link Connection Objects

Analysis Manager

browsing Sales cubes, Loading Historical Data, Loading and Verifying Monthly Data

Analysis Services Processing task, Chapter 4: Creating Advanced DTS Tasks

Analysis Services tasks, Creating a Starter DTS Package

access permissions for, Creating the SalesCubeProcessing Subpackage

adding to MasterUpdate packages, Restoring the Analysis Services Database and Adding an Analysis Services Processing Task

adding to packages, Creating the SalesCubeProcessing Subpackage, Ensuring Execution Order and Testing the New Steps

bypassing in MasterUpdate packages, Adding Step Bypass and Logging Steps

execution order, Ensuring Execution Order and Testing the New Steps

logging bypasses, Adding Step Bypass and Logging Steps

logging success or failure, Adding Step Bypass and Logging Steps

Microsoft SQL Server Accelerator for Business Intelligence, Creating the SalesCubeProcessing Subpackage

restoring databases to instances, Restoring the Analysis Services Database and Adding an Analysis Services Processing Task

testing execution, Ensuring Execution Order and Testing the New Steps

Visual Basic 6 for, Creating the SalesCubeProcessing Subpackage, Creating the SalesCubeProcessing Subpackage

anomalous results

avoiding, Plan Carefully When Executing Package Steps in Parallel

applications, Connection Objects

audit table

creating in SQL Server, Creating an Audit Table in SQL Server

audit trail

of the execution history for the data movement application, Chapter 8: Incorporating Error Handling into DTS Packages

AuditEvents table

creating, Creating an Audit Table in SQL Server

enabling rows added and rows with errors to be recorded, Modifying the AuditEvents Table to Record Row Processing Information

modifying to record row processing information, Modifying the AuditEvents Table to Record Row Processing Information

testing the use of, Testing the Use of the AuditEvents Table, Testing the Use of the AuditEvents Table

writing entries to, Creating Logging Steps in the MasterUpdate Package, Creating Logging Steps in UpdateProductDim Package

Auto Generate

clicking to regenerate to the original Transact -SQL statement, Importing Data Using the DTS Import/Export Wizard

auto-mapped transformations

reviewing, Creating a Data Load Package in DTS Designer