Index_C

C

caching

turning on in the Package Properties dialog box, Important

case sensitivity

of global variable names , Important

CD-ROM with this book

BeforeYouBegin.cmd batch file, Important

Chaos isolation level, Enabling and Configuring Transactions

checkpointing

enlisting tasks into multiple transactions, Enlist tasks into multiple transactions using checkpointing

checksum value short identifier

supplied by DTS, Saving Packages

CInt conversion function, Adding Branching Steps to the UpdateCustomerDim Package

collations

copying objects and data between SQL Server 2000 databases with differing, Important

column constraint

adding, Importing Data Using the DTS Import/Export Wizard

column data lengths

changing, Importing Data Using the DTS Import/Export Wizard

column data type

changing, Importing Data Using the DTS Import/Export Wizard

column delimiter

specifying, Importing Data Using the DTS Import/Export Wizard

column identifiers

supplied by DTS, Saving Packages

Column Mappings tab

Mappings box, Importing Data Using the DTS Import/Export Wizard

column-level data lineage, Saving Packages

implementing, Saving Packages

columns

adding to the AuditEvents table, Modifying the AuditEvents Table to Record Row Processing Information

mapping from the source query to the destination table, Creating a Data Load Package in DTS Designer

COM objects

accessing data pump phases, Accessing the Multiphase Data Pump

creating transformations using a single, Creating a Data Load Package in DTS Designer

in transformation operations, View a Transform Data task

command prompt window

retrieving the last command executed, Enabling Package Logging

Commit On Successful Package Completion check box, Enlist tasks that execute sequentially in a single transaction

in the Workflow Properties dialog box, Enabling and Configuring Transactions

Commit Transactions On Successful Completion Of This Step check box, Enlist tasks into multiple transactions using checkpointing

committed batches

rolling back, Important

Config.ini file

creating, Using the Dynamic Properties Task

selecting a Key value for, Using the Dynamic Properties Task

specifying as the source for the UDLPath property, Using the Dynamic Properties Task

Config.ini initialization file

adding a subkey to the registry containing the location of, Adding a Registry Entry

adding exception file location information, Updating Exception File Location Information Dynamically for UpdateProductDim Package Tasks

adding exception file location information to, Updating Exception File Location Information Dynamically for UpdateCustomerDim Package Tasks

adding subpackage location information to, Passing the giConfigID Value to Subpackages and Dynamically Configuring the Execute Package Tasks in the MasterUpdate ...

reading exception file locations from, Updating Exception File Location Information Dynamically for UpdateCustomerDim Package Tasks

reading exception file locations into the UpdateProductDim package, Updating Exception File Location Information Dynamically for UpdateProductDim Package Tasks

reading subpackage location information into the MasterUpdate package, Passing the giConfigID Value to Subpackages and Dynamically Configuring the Execute Package Tasks in the MasterUpdate ...

ConfigFile registry key value

changing in the Registry Editor, Executing the Data Movement Application Packages from a New Folder Location

reading into a global variable in the MasterUpdate package, Updating the Dynamic Properties Task in the MasterUpdate Package with a Registry Key Value

reading into a global variable in the UpdateCustomerDim package, Updating the Dynamic Properties Task in the UpdateCustomerDim Package with a Registry Key Value

reading into a global variable in the UpdateProductDim package, Updating the Dynamic Properties Task in the UpdateProductDim Package with a Registry Key Value

ConfigFile subkey

creating, Adding a Registry Entry

ConfigID column

in the global variable configuration table, Creating a Configuration Table in SQL Server

configuration ID

retrieving appropriate global variable values, Enabling Package Branching

configuration ID parameter

creating a global variable to store the value for, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table, Updating Global Variable Values in the UpdateProductDim Package from the Configuration Table

configuration ID value

setting for the MasterUpdate package, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

configuration table

creating in SQL Server, Creating a Configuration Table in SQL Server

testing configurations, Testing Configuration Table Configurations

Config2.cmd

executing, Testing the Recording of Row Processing Information

connection information

embedding in packages, Using Data Link Connection Objects

connection objects, Connection Objects

adding to enable tasks to execute in parallel, Test the TransactionDemo package with two transactions, Add separate connections to the TransactionDemo package

changing the properties of, Connection Objects

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

creating to the SBS_OLAP database, Creating a New Package in DTS Designer, Creating a Data Load Package in DTS Designer

creating to the SBS_OLTP database, Creating a Data Load Package in DTS Designer

descriptive names for, Connection Objects

displaying renamed , Add separate connections to the TransactionDemo package

displaying the UDLPath property, Using the Dynamic Properties Task

dynamically configuring the location of the UDL file used by, Using the Dynamic Properties Task

in DTS packages, Chapter 1: Jumping into DTS

indicating the direction of data flow between, View a Transform Data task

multiple using the same UDL file, Using Data Link Connection Objects

opening to verify selection of the Always Read Properties From UDL File check box, Using Data Link Connection Objects

renaming in a package, Connection Objects

steps for setup, Creating a Starter DTS Package

supporting the execution of multiple tasks in parallel, Connection Objects

tasks sharing, ImportantTasks

to binding tables, Important

connection parameters

defining, Connection Objects

connection types

supporting joining transactions, Enlisting Tasks in Transactions

connections

configuring in the PopulateTimeDimension package to use a UDL file, Using Data Link Connection Objects

configuring in the UpdateCustomerDim package to use a UDL file, Using Data Link Connection Objects

configuring in the UpdateProductDim package to use a UDL file, Using Data Link Connection Objects

configuring LoadHistoricalData to use UDL files, Using Data Link Connection Objects

keeping open for lookup queries, Performing Lookup Queries in a Transform Data Task

constant values

retrieving values for package and task properties, Using the Dynamic Properties Task

constraints

ignoring on relational tables during data loading, View a Transform Data task

conversion functions

required in ActiveX scripts, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

Copy All Objects check box

selecting, Copying Objects and Data Using the DTS Import/Export Wizard

copy column transformation

changing to an ActiveX script transformation, Performing Lookup Queries in a Transform Data Task

Copy Column transformation option, Creating a Data Load Package in DTS Designer

Copy Database Wizard, Copying Objects and Data Using the DTS Import/Export Wizard

Copy Objects And Data Between SQL Server Databases

clicking, Copying Objects and Data Using the DTS Import/Export Wizard

Copy SQL Server Objects task, Chapter 4: Creating Advanced DTS Tasks

CountryCodes lookup table

creating in the SBS_OLAP database, Performing Lookup Queries in a Transform Data Task

using to transform country values, Performing Lookup Queries in a Transform Data Task

CountryCodes.sql script file, Performing Lookup Queries in a Transform Data Task

Create Table SQL Statement dialog box

closing, Importing Data Using the DTS Import/Export Wizard

CREATE TABLE statement

task executing, View an Execute SQL task

CreateAuditEventsTable.sql script, Creating an Audit Table in SQL Server

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

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

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

Ctrl key

selecting multiple items on the design sheet, Precedence Constraints

custom tasks

building, Important

customer data

inserting into the CustomerDim table, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

updating in the CustomerDim table, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

Customer Insert stored procedure

creating, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

Customer Update stored procedure

creating, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

CustomerDim table

adding the BatchID column to, Modifying SQL Server Objects to Support Batch Control

inserting new customer data into, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

populating in the SBS_OLAP database, Creating a Data Load Package in DTS Designer

updating customer data in, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

CustomerDimInsertValues stored procedure

adding an INSERT statement to add a row into AuditEvents, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

calling, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

creating, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

modifying to report rows inserted or updated, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

CustomerDimUpdateValues stored procedure

adding an INSERT statement to add a row into AuditEvents, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

calling, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

creating, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

modifying to report rows inserted or updated, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

CustomerDimValues.sql script, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

CustomersDestination connection

creating, Creating a Data Load Package in DTS Designer

CustomersDestination connection object

modifying to use the SBS_OLAP.udl file, Using Data Link Connection Objects

selecting as the destination for extracted data, Creating a Data Load Package in DTS Designer

CustomersSource connection object

creating, Creating a Data Load Package in DTS Designer

modifying to use the SBS_OLTP.udl file, Using Data Link Connection Objects

selecting to obtain source data, Creating a Data Load Package in DTS Designer

CustomerStage connection object

modifying to use the SBS_OLAP.udl file, Using Data Link Connection Objects

CustomerStage table

records in, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package