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

L

Leave This Dialog Box Open After Adding A Setting check box

in the Package Properties dialog box, Using the Dynamic Properties Task

lineage columns

configuring Load SalesFact Table task to use, Saving Packages

tracking packages modifying particular rows, Saving Packages

lineage information

enabling the generation of, Saving Packages

lineage values

displaying details about package versions responsible for generating, Saving Packages

lineage variable values

in LineageFull and LineageShort columns, Saving Packages

LineageShort column

checksum values displayed in, Saving Packages

linking

package meta data, Saving Packages

Load CustomerDim Table Transform Data task

creating, Creating a Data Load Package in DTS Designer

Load CustomerStage Table step

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

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

recording rows completed and rows with errors in UpdateCustomerDim, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

load dimension table steps

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

Load ProductDim Table Transform Data task

creating, Creating a Data Load Package in DTS Designer

Load ProductStage Table step

logging the failure of in UpdateProductDim, Creating Logging Steps in UpdateProductDim Package

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

recording rows completed and rows with errors, Reporting Row Processing Information by UpdateProductDim Package Tasks

Load Sales Fact Table task

creating, Creating a Data Load Package in DTS Designer

Load SalesFact Table task

configuring to use lineage columns, Saving Packages

Load SQL Script

in Query Analyzer, Creating a New Package in DTS Designer

Load Time Dimension step

executing in the PopulateTimeDimension package, Creating a New Package in DTS Designer

Load 1996 Sales Data task

creating, Creating a Data Load Package in DTS Designer

Load 1997 Sales Data task

creating, Creating a Data Load Package in DTS Designer

LoadCustomers.sql script, Creating a Data Load Package in DTS Designer

LoadCustomerStageTableExceptionFile.txt file, Adding Package Logging and Error Handling Steps to Packages

LoadCustomerStageTableExceptionFile.txt log, Testing the Recording of Row Processing Information

LoadCustomerStageTableExceptionFile.txt.Dest file, Adding Package Logging and Error Handling Steps to Packages

LoadCustomerStageTableExceptionFile.txt.Dest log, Testing the Recording of Row Processing Information

LoadCustomerStageTableExceptionFile.txt.Source file, Adding Package Logging and Error Handling Steps to Packages

LoadCustomerStageTableExceptionFile.txt.Source log, Testing the Recording of Row Processing Information

LoadHistoricalData package, Loading Historical Data

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

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

configuring to use UDL files, Using Data Link Connection Objects

creating, Creating a Data Load Package in DTS Designer

creating connection objects for, Creating a Data Load Package in DTS Designer

executing, Creating a Data Load Package in DTS Designer, Testing the Recording of Row Processing Information

executing to delete all test data from dimension tables, Testing the Steps That Generate and Add the BatchID Value

loading in DTS Designer, Saving Packages

saving as a Visual Basic file, Saving Packages

testing the execution of, Using the Dynamic Properties Task

loading historical data in data movement applications, Loading Historical Data

loading monthly data in data movement applications, Loading and Verifying Monthly Data

LoadProducts.sql script, Creating a Data Load Package in DTS Designer

LoadSalesFact.sql script, Creating a Data Load Package in DTS Designer

local server

selecting, Importing Data Using the DTS Import/Export Wizard

log load dimension table bypass step

adding to the UpdateCustomerDim package, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

adding to the UpdateProductDim package, Adding Branching Steps to UpdateProductDim Package

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

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

log package bypass step

adding to the UpdateCustomerDim package, Adding Branching Steps to the UpdateCustomerDim Package

adding to the UpdateProductDim package, Adding Branching Steps to UpdateProductDim Package

in UpdateCustomerDim, Configuring Steps and Execution Order in the UpdateCustomerDim Package

modifying to log the bypass of UpdateCustomerDim, Creating Logging Steps in the UpdateCustomerDim Package

Log Package Execution To SQL Server check box, Enabling Package Logging, Adding Package Logging and Error Handling Steps to Packages

LogBatchIDGeneration.sql script, Creating Logging Steps in the MasterUpdate Package

LogBypass step

editing in the UpdateProductDim package, Creating Logging Steps in UpdateProductDim Package

LogBypassPackage step

script calling for, Adding Branching Steps to the UpdateCustomerDim Package

LogFileName property

dynamically configuring in MasterUpdate, Adding Package Logging and Error Handling Steps to Packages

logging

bypasses of tasks, Adding Step Bypass and Logging Steps

DTS package activity, Enabling Package Logging

enabling for subpackages, Adding Package Logging and Error Handling Steps to Packages

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

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

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

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

success of tasks, Adding Step Bypass and Logging Steps

logging and error handling steps

adding to packages, Adding Package Logging and Error Handling Steps to Packages

logging steps

creating in the MasterUpdate package, Creating Logging Steps in the MasterUpdate Package, Creating Logging Steps in the MasterUpdate Package

creating in the UpdateCustomerDim package, Creating Logging Steps in the UpdateCustomerDim Package, Creating Logging Steps in the UpdateCustomerDim Package

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

logging tasks

adding to packages, Testing the Steps That Generate and Add the BatchID Value, Creating Logging Steps in UpdateProductDim Package

login account

for packages stored in SQL Server or in Meta Data Services, Securing Packages

logins

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

LogUpdateCustomerDimDeleteBranchExecuted.sql script, Creating Logging Steps in the UpdateCustomerDim Package

LogUpdateCustomerDimInsertAndUpdateDimTableBypassed.sql script, Creating Logging Steps in the UpdateCustomerDim Package

LogUpdateCustomerDimInsertCustomerDimTableFailure.sql script, Creating Logging Steps in the UpdateCustomerDim Package

LogUpdateCustomerDimInsertCustomerDimTableSuccess.sql script, Creating Logging Steps in the UpdateCustomerDim Package

LogUpdateCustomerDimLoadCustomerStageTableFailure.sql script, Creating Logging Steps in the UpdateCustomerDim Package

LogUpdateCustomerDimLoadCustomerStageTableLoadRows.bas script, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

LogUpdateCustomerDimLoadCustomerStageTableSuccess.sql script, Creating Logging Steps in the UpdateCustomerDim Package

LogUpdateCustomerDimPackageBypassed.sql script, Creating Logging Steps in the UpdateCustomerDim Package

LogUpdateCustomerDimUpdateCustomerDimTableFailure.sql script, Creating Logging Steps in the UpdateCustomerDim Package

LogUpdateCustomerDimUpdateCustomerDimTableSuccess.sql script, Creating Logging Steps in the UpdateCustomerDim Package

LogUpdateDimensionsComplete.sql script, Creating Logging Steps in the MasterUpdate Package

LogUpdateProductDimDeleteBranchExecuted.sql script, Creating Logging Steps in UpdateProductDim Package

LogUpdateProductDimInsertAndUpdateDimTableBypassed.sql script, Creating Logging Steps in UpdateProductDim Package

LogUpdateProductDimInsertOrUpdateProductDimLoadRows.bas script, Reporting Row Processing Information by UpdateProductDim Package Tasks

LogUpdateProductDimInsertOrUpdateProductDimTableFailure.sql script, Creating Logging Steps in UpdateProductDim Package

LogUpdateProductDimInsertOrUpdateProductDimTableSuccess.sql, Creating Logging Steps in UpdateProductDim Package

LogUpdateProductDimLoadProductStageTableFailure.sql script, Creating Logging Steps in UpdateProductDim Package

LogUpdateProductDimLoadProductStageTableLoadRows.bas script, Reporting Row Processing Information by UpdateProductDim Package Tasks

LogUpdateProductDimLoadProductStageTableSuccess.sql script, Creating Logging Steps in UpdateProductDim Package

LogUpdateProductDimPackageBypassed.sql script, Creating Logging Steps in UpdateProductDim Package

long identifier

supplied by DTS, Saving Packages

lookup queries, Chapter 4: Creating Advanced DTS Tasks, Performing Lookup Queries in a Transform Data Task

adding to existing packages, Performing Lookup Queries in a Transform Data Task

calling with ActiveX scripts, Performing Lookup Queries in a Transform Data Task

creating in a Transform Data task, Performing Lookup Queries in a Transform Data Task

modifying transformation scripts to use<$endrange, Performing Lookup Queries in a Transform Data Task

modifying transformation scripts to use<$startrange, Performing Lookup Queries in a Transform Data Task

performing in a Transform Data task, Performing Lookup Queries in a Transform Data Task

separate connections for, Performing Lookup Queries in a Transform Data Task

testing, Performing Lookup Queries in a Transform Data Task

Lookups tab

clicking, Performing Lookup Queries in a Transform Data Task