Microsoft SQL Server 2000 DTS Step by Step (Step by Step (Microsoft))

U

UDL files, Using Data Link Connection Objects

configuring, Using Data Link Connection Objects

configuring connections to use, Using Data Link Connection Objects

connecting to the default instance on the local server, Using Data Link Connection Objects

creating, Using Data Link Connection Objects

editing from within DTS, Using Data Link Connection Objects

multiple connection objects using, Using Data Link Connection Objects

UDLPath property

specifying the initialization file as the source, Using the Dynamic Properties Task

uncommitted transactions

completing packages with, Enabling and Configuring Transactions

undefined Transform Data task, Creating a Data Load Package in DTS Designer

Unicode

generating scripts in, Important

Update Data In CustomerDim Table step

logging the failure of in the UpdateCustomerDim package, Creating Logging Steps in the UpdateCustomerDim Package

logging the success of in the UpdateCustomerDim package, Creating Logging Steps in the UpdateCustomerDim Package

Update query

adding the BatchID column to the SET list, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package

UPDATE statement, Using Parameterized Queries in a Data Driven Query Task

UPDATE statements

avoiding termination by errors, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

update stored procedure

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

Update.txt script, Using Parameterized Queries in a Data Driven Query Task

UpdateCustomerDim package

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

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

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

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

adding a lookup query to, Performing Lookup Queries in a Transform Data Task

adding branching global variables , Adding Branching Steps to the UpdateCustomerDim Package

adding branching steps to, Adding Branching Steps to the UpdateCustomerDim Package, Adding Branching Steps to the UpdateCustomerDim Package

adding global variables, Adding Branching Steps to UpdateProductDim Package

adding precedence constraints to ensure the proper order of package execution, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

adding the giBatchID global variable to, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

adding the Log Load Dimension Table Bypass step to, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

calling, Calling Subpackages

configuring a Dynamic Properties task in, Using the Dynamic Properties Task

configuring connections to use a UDL file, Using Data Link Connection Objects

configuring giMaxErrorCount in, Dynamically Changing Global Variable Values in Another Package

configuring steps and execution order in, Configuring Steps and Execution Order in the UpdateCustomerDim Package, Configuring Steps and Execution Order in the UpdateCustomerDim Package

configuring to execute the Properties From INI File step first, Using the Dynamic Properties Task

creating an Execute SQL task to call the CustomerDimUpdateValues stored procedure, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

creating logging steps in, Creating Logging Steps in the UpdateCustomerDim Package, Creating Logging Steps in the UpdateCustomerDim Package

creating user -friendly names for new steps in, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

enabling package logging and error handling, Adding Package Logging and Error Handling Steps to Packages

ensuring package step execution in proper order, Updating the Dynamic Properties Task in the UpdateCustomerDim Package with a Registry Key Value, Configuring Steps and Execution Order in the UpdateCustomerDim Package, Configuring Steps and Execution Order in the UpdateCustomerDim Package

executing with a modified MaximumErrorCount property, Working with Exception Files

incorporating the BatchID value into tasks in, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

logging the bypass of, Creating Logging Steps in the UpdateCustomerDim Package

logging the bypass of load dimension table steps in UpdateCustomerDim, Creating Logging Steps in the UpdateCustomerDim Package

logging the execution of the delete branch of, Creating Logging Steps in the UpdateCustomerDim Package

logging the failure of Load CustomerStage Table step, Creating Logging Steps in the UpdateCustomerDim Package

logging the failure of the Insert New Data In CustomerDim Table step, Creating Logging Steps in the UpdateCustomerDim Package

logging the failure of the Update Data In CustomerDim Table step, Creating Logging Steps in the UpdateCustomerDim Package

logging the success of the Insert New Data In CustomerDim Table step, Creating Logging Steps in the UpdateCustomerDim Package

logging the success of the Update Data In CustomerDim Table step, Creating Logging Steps in the UpdateCustomerDim Package

logging the successful execution of, Creating Logging Steps in the UpdateCustomerDim Package

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

retrieving each global variable from the PackageGVs table, Updating Global Variable Values in the UpdateCustomerDim Package from the Configuration Table

specifying step execution order in, Specifying Step Execution Order in the UpdateCustomerDim Package, Specifying Step Execution Order in the UpdateCustomerDim Package

storing the location of the SBS_OLAP.udl file in a global variable, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

tasks reporting row processing information, Reporting Row Processing Information by UpdateCustomerDim Package Tasks, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

testing a lookup query in, Performing Lookup Queries in a Transform Data Task

testing the execution of, Working with Exception Files, Using the Dynamic Properties Task

updating global variable values from the configuration table, Updating Global Variable Values in the UpdateCustomerDim Package from the Configuration Table, Updating Global Variable Values in the UpdateCustomerDim Package from the Configuration Table

UpdateCustomerDim package tasks

updating exception file location information dynamically for, Updating Exception File Location Information Dynamically for UpdateCustomerDim Package Tasks

UpdateProductDim package

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

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

adding a Data Driven Query task, Using Parameterized Queries in a Data Driven Query Task

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

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

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

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

adding branching steps to, Adding Branching Steps to UpdateProductDim Package, Adding Branching Steps to UpdateProductDim Package

adding the giBatchID global variable to, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package

calling, Calling Subpackages

configuring a Dynamic Properties task in, Using the Dynamic Properties Task

configuring a Dynamic Properties task to use global variable values, Using the Dynamic Properties Task

configuring connections to use a UDL file, Using Data Link Connection Objects

configuring precedence constraints in, Specifying Step Execution Order in the UpdateProductDim Package, Specifying Step Execution Order in the UpdateProductDim Package

configuring steps and execution order in, Configuring Steps and Execution Order in the UpdateProductDim Package, Configuring Steps and Execution Order in the UpdateProductDim Package

configuring the SetPropertiesFromInitializationFile step to execute first, Using the Dynamic Properties Task

creating logging steps in, Creating Logging Steps in UpdateProductDim Package, Creating Logging Steps in UpdateProductDim Package

editing the LogBypass step, Creating Logging Steps in UpdateProductDim Package

enabling package logging and error handling, Adding Package Logging and Error Handling Steps to Packages

ensuring package execution in the proper order, Configuring Steps and Execution Order in the UpdateProductDim Package, Configuring Steps and Execution Order in the UpdateProductDim Package

ensuring package step execution in proper order, Updating the Dynamic Properties Task in the UpdateProductDim Package with a Registry Key Value

incorporating the BatchID value into tasks in, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package

logging the bypass of the Insert Or Update ProductDim Table step in, Creating Logging Steps in UpdateProductDim Package

logging the execution of the delete branch of, Creating Logging Steps in UpdateProductDim Package

logging the failure of the Insert Or Update ProductDim Table step in, Creating Logging Steps in UpdateProductDim Package

logging the failure of the Load ProductStage Table step in, Creating Logging Steps in UpdateProductDim Package

logging the success of the Insert Or Update ProductDim Table step in, Creating Logging Steps in UpdateProductDim Package

logging the successful execution of the Load ProductStage Table step in, Creating Logging Steps in UpdateProductDim Package

modifying a Data Driven Query task in, Using Parameterized Queries in a Data Driven Query Task

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

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

recording rows completed and rows with errors by the Load ProductStage Table step, Reporting Row Processing Information by UpdateProductDim Package Tasks

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

specifying step execution order in, Specifying Step Execution Order in the UpdateProductDim Package, Specifying Step Execution Order in the UpdateProductDim Package

starter DTS package based on, Creating a Starter DTS Package

storing the location of the SBS_OLAP.udl file in a global variable, Reporting Row Processing Information by UpdateProductDim Package Tasks

tasks reporting row processing information, Reporting Row Processing Information by UpdateProductDim Package Tasks, Reporting Row Processing Information by UpdateProductDim Package Tasks

testing a Data Driven Query task, Using Parameterized Queries in a Data Driven Query Task, Important

testing different configuration values, Creating Delete Configurations to Execute the Branches in the Subpackages

testing the execution of, Using the Dynamic Properties Task

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

updating the Dynamic Properties task with a registry key value, Updating the Dynamic Properties Task in the UpdateProductDim Package with a Registry Key Value, Updating the Dynamic Properties Task in the UpdateProductDim Package with a Registry Key Value

UpdateSalesFacts package, Adding Branching Steps to the UpdateSalesFacts Package, Adding Branching Steps to the UpdateSalesFacts Package

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

ActiveX Script task, adding, Adding Branching Steps to the UpdateSalesFacts Package, Adding Branching Steps to the UpdateSalesFacts Package

adding new data, Creating the Steps That Load Data into the SalesStage and SalesFact Tables, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

BatchID column creation, Creating the Steps That Load Data into the SalesStage and SalesFact Tables, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

BatchSize property, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package

branching steps, Adding Branching Steps to the UpdateSalesFacts Package, Adding Branching Steps to the UpdateSalesFacts Package

Bulk Insert task, Creating the Steps That Load Data into the SalesStage and SalesFact Tables, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

calling from MasterUpdate package, Calling the UpdateSalesFacts Subpackage from the MasterUpdate Package, Calling the UpdateSalesFacts Subpackage from the MasterUpdate Package

config.ini file, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package

configuring, Loading and Verifying Monthly Data

creating based on StarterDTS, Creating the Steps That Load Data into the SalesStage and SalesFact Tables, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

delete phases, adding, Adding Branching Steps to the UpdateSalesFacts Package, Adding Branching Steps to the UpdateSalesFacts Package

dropped rows, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

dynamic configuration elements, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package

execution order, Configuring User-Friendly Names and Adding Precedence Constraints to Ensure That Steps Execute in the Proper Order

global variables, adding, Adding Branching Steps to the UpdateSalesFacts Package

logging bypass steps, Adding Logging and Error Reporting Steps to the UpdateSalesFacts Package, Adding Logging and Error Reporting Steps to the UpdateSalesFacts Package

logging error rows, Adding Logging and Error Reporting Steps to the UpdateSalesFacts Package, Adding Logging and Error Reporting Steps to the UpdateSalesFacts Package

logging load table steps, Adding Logging and Error Reporting Steps to the UpdateSalesFacts Package, Adding Logging and Error Reporting Steps to the UpdateSalesFacts Package, Adding Logging and Error Reporting Steps to the UpdateSalesFacts Package, Adding Logging and Error Reporting Steps to the UpdateSalesFacts Package

logging phase execution, Adding Logging and Error Reporting Steps to the UpdateSalesFacts Package, Adding Logging and Error Reporting Steps to the UpdateSalesFacts Package

MaximumErrors property, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package

overview, Creating and Calling a Package That Populates the SalesFact Table, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

precedence constraints, Configuring User-Friendly Names and Adding Precedence Constraints to Ensure That Steps Execute in the Proper Order

Properties From INI File step, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package

purpose of, Chapter 9: Completing the Data Movement Application

steps in creation, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

stored procedure for, Creating the Steps That Load Data into the SalesStage and SalesFact Tables, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

testing, Testing the Data Movement Application with the UpdateSalesFacts Package, Testing the Data Movement Application with the UpdateSalesFacts Package

user-friendly names for steps, Configuring User-Friendly Names and Adding Precedence Constraints to Ensure That Steps Execute in the Proper Order

UpdateTimeDim.cmd batch file, Executing Packages

adding the /L parameter, Enabling Package Logging

Use A Query To Specify The Data To Transfer

clicking, Importing Data Using the DTS Import/Export Wizard

clicking in the DTS Import/Export Wizard, Exporting Data Using the DTS Import/Export Wizard

Use Collation check box

in the DTS Import/Export Wizard, Important

Use Default Options check box

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

Use Fast Load check box

for a Transform Data task, View a Transform Data task

Use Transactions check box, Enlist tasks that execute sequentially in a single transaction

user passwords

securing DTS packages, Securing Packages Using Passwords

User variable

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

user-defined error messages

copying between SQL Server instances, Chapter 4: Creating Advanced DTS Tasks

user-friendly names

creating for new steps in UpdateCustomerDim, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

creating for package steps, Adding Branching Steps to the UpdateCustomerDim Package

creating for steps in the UpdateProductDim package, Configuring Steps and Execution Order in the UpdateProductDim Package, Configuring Steps and Execution Order in the UpdateProductDim Package

creating for steps in UpdateCustomerDim, Configuring Steps and Execution Order in the UpdateCustomerDim Package, Configuring Steps and Execution Order in the UpdateCustomerDim Package

user-friendly names for steps, Configuring User-Friendly Names and Adding Precedence Constraints to Ensure That Steps Execute in the Proper Order