Index_T


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



Microsoft SQL Server 2000 DTS Step by Step
Microsoft SQL Server 2000 DTS Step by Step (Step by Step (Microsoft))
ISBN: 0735619166
EAN: 2147483647
Year: 2003
Pages: 87
Authors: Carl Rabeler

Similar book on Amazon

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net