Microsoft SQL Server 2000 DTS Step by Step (Step by Step (Microsoft))
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