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

T

table locks

specifying for Bulk Insert, Creating a Data Load Package in DTS Designer

table-level locking

enabling during data loading, View a Transform Data task

tables

adding to the SBS_OLAP database, Creating a New Package in DTS Designer

as data sources, Important

materializing views to, Important

naming in destination databases, Importing Data Using the DTS Import/Export Wizard

resetting for data movement, Resetting the Data Movement Application in the SBS_OLAP Database

selecting in an Access database to copy, Importing Data Using the DTS Import/Export Wizard

task description

of a Transform Data task, View a Transform Data task

task execution

out-of-order, Precedence Constraints

task flow

changing to parallel, Change the task flow to parallel

task priority value

setting at run time, Configuring Execution Priority

Task References dialog box, Connection Objects

tasks, Tasks , View an Execute SQL task

building custom, Important

compared to steps, Important

configuring for failure, Configuring the Definition of Package Failure

configuring the parallel execution of, Configuring Parallel Execution of Tasks

connecting to data stores, Connection Objects

creating to load historical data into the SBS_OLAP database, Creating a Data Load Package in DTS Designer

enabling to execute in parallel on the main thread, Enable the tasks executing in parallel to execute on the main thread

enabling to join a transaction, Enlisting Tasks in Transactions

enlisting in transactions, Enlisting Tasks in Transactions

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

enlisting to execute sequentially in a single transaction, Enlist tasks that execute sequentially in a single transaction

executed by the DTS Import/Export Wizard, Importing Data Using the DTS Import/Export Wizard

in DTS packages, Chapter 1: Jumping into DTS

joining transactions allowed for specific, Enlisting Tasks in Transactions

not supporting free-threaded, Working with Tasks That Are Not Free-Threaded

parallel execution of, Calling Subpackages

pre-built, Chapter 4: Creating Advanced DTS Tasks

running not free-threaded, Working with Tasks That Are Not Free-Threaded

sharing connection objects, ImportantTasks

sharing one connection object, Creating a Data Load Package in DTS Designer

templates for data movement applications, Chapter 9: Completing the Data Movement Application

TestBatchExecution.sql script

executing, Testing the Steps That Generate and Add the BatchID Value

re-executing, Testing the Steps That Generate and Add the BatchID Value

text file

copying to a SQL Server database, Importing Data Using the DTS Import/Export Wizard

determining the properties of, Importing Data Using the DTS Import/Export Wizard

enabling logging of package execution to, Enabling Package Logging

Text File (Source) connection object

viewing, Connection Objects

text files, Connection Objects

threads

executing tasks on separate, Working with Tasks That Are Not Free-Threaded

Time dimension

adding members , Loading Historical Data, Loading and Verifying Monthly Data

TimeDim table

creating a stored procedure to populate, Creating a New Package in DTS Designer

creating an Execute SQL task to populate, Creating a New Package in DTS Designer

populating in the SBS_OLAP database, Creating a New Package in DTS Designer

TimeDimBuild stored procedure

assigning global variables for, Important

calling to add time records to the TimeDim table, Creating a New Package in DTS Designer

creating, Creating a New Package in DTS Designer

Transact -SQL BULK INSERT statement, Important

Transact-SQL code

using to access data stored within a SQL Server database, The Execute SQL Task

Transact-SQL INSERT or UPDATE statements

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

Transact-SQL JOIN statement

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

Transact-SQL methods

counting the number of rows inserted or update, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

Transact-SQL query

entering directly, Importing Data Using the DTS Import/Export Wizard

Transact-SQL script

adding tables to the SBS_OLAP database, Creating a New Package in DTS Designer

modifying, Importing Data Using the DTS Import/Export Wizard

Transact-SQL syntax

verifying, Importing Data Using the DTS Import/Export Wizard

transaction checkpoint task

labelling, Enlist tasks into multiple transactions using checkpointing

transaction checkpointing

for multiple transactions, Use Transaction Checkpointing for Multiple Transactions

transaction configuration options

accessing, Enabling and Configuring Transactions

transaction control

adding to the TransactionDemo package, Test the TransactionDemo package

testing for the TransactionDemo package, Test the TransactionDemo package

testing the TransactionDemo package without, Test the TransactionDemo package, Test the TransactionDemo package

transaction isolation levels, Enabling and Configuring Transactions

configuring for every task, Enabling and Configuring Transactions

transaction rollbacks

in a subpackage, Inheriting Transactions

transactional and non-transactional updates

using separate connections to enable, Enlisting Tasks in Transactions

TransactionDemo package

adding separate connections to, Add separate connections to the TransactionDemo package, Add separate connections to the TransactionDemo package

selecting, Test the TransactionDemo package

testing the execution of, Test the execution of the TransactionDemo package with parallel steps, Test the execution of the TransactionDemo package with parallel steps

testing with transaction control, Test the TransactionDemo package

testing with two transactions, Test the TransactionDemo package with two transactions, Test the TransactionDemo package with two transactions

testing without transaction control, Test the TransactionDemo package, Test the TransactionDemo package

transactions, Working with Transactions

branching upon success or failure of, Branch upon the Success or Failure of a Transaction

configuring tasks to execute as part of a single, Enlist tasks that execute sequentially in a single transaction

enabling and configuring, Enabling and Configuring Transactions, Important

enlisting tasks in, Enlisting Tasks in Transactions

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

guidelines for working with, Considerations When Working with Transactions, Enable the tasks executing in parallel to execute on the main thread

inheriting, Inheriting Transactions

TransactionTextScript.sql script, Test the TransactionDemo package

Transfer Databases task, Chapter 4: Creating Advanced DTS Tasks

Transfer Error Messages task, Chapter 4: Creating Advanced DTS Tasks

Transfer Jobs task, Chapter 4: Creating Advanced DTS Tasks

Transfer Logins task, Chapter 4: Creating Advanced DTS Tasks

Transfer Master Stored Procedures task, Chapter 4: Creating Advanced DTS Tasks

Transform Data task, The Transform Data task, Chapter 4: Creating Advanced DTS Tasks

compared to a Data Driven Query task, Using Parameterized Queries in a Data Driven Query Task

compared to Bulk Insert, Important

creating, Creating a Data Load Package in DTS Designer

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

determining if any rows were not inserted by, Adding Package Logging and Error Handling Steps to Packages

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

transaction participation supported for, Enlisting Tasks in Transactions

viewing, View a Transform Data task

Transform Data Task Properties dialog box, Creating a Data Load Package in DTS Designer

Transform Failure subphase

of the Post Row Transform phase, Accessing the Multiphase Data Pump

Transform Information As It Is Copied To The Destination

clicking to view transformation options, Importing Data Using the DTS Import/Export Wizard

transformation options

viewing, Importing Data Using the DTS Import/Export Wizard

transformation script

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

transformation tasks

configuring exception files for, Working with Exception Files

defining exception files for, Working with Exception Files

invalidating by modifying a connection object, Connection Objects

transformation types

predefined, Creating a Data Load Package in DTS Designer

transformations

deleting all existing, Creating a Data Load Package in DTS Designer

removing, Using Parameterized Queries in a Data Driven Query Task

Transformations mapping tab

of the Transform Data task or the Data Drive Query task, Accessing the Multiphase Data Pump

Transformations tab

in DTS Designer, View a Transform Data task

TRUNCATE statesments

resetting databases with, Resetting the Data Movement Application in the SBS_OLAP Database

TRUNCATE TABLE statement

resetting the IDENTITY property in each table, Creating a Data Load Package in DTS Designer

Truncate Tables task

creating, Creating a Data Load Package in DTS Designer

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

Turn On Cache check

selecting, Accessing the Multiphase Data Pump

type mismatches

preventing, Performing Lookup Queries in a Transform Data Task