Index_D


D

data
consolidating and filtering using a SQL query, Importing Data Using the DTS Import/Export Wizard
copying between SQL Server databases, Importing Data Using the DTS Import/Export Wizard
copying between SQL Server databases using a SQL query, Importing Data Using the DTS Import/Export Wizard
copying between SQL Server 2000 databases, Copying Objects and Data Using the DTS Import/Export Wizard
copying from a Microsoft Access database to a SQL Server database, Importing Data Using the DTS Import/Export Wizard
copying from a SQL Server database to an Excel worksheet, Exporting Data Using the DTS Import/Export Wizard
copying from a text file to a SQL Server database, Importing Data Using the DTS Import/Export Wizard
exporting from SQL Server, Exporting Data Using the DTS Import/Export Wizard
data conversion errors
errors caused by, Accessing the Multiphase Data Pump
data destination
creating, Importing Data Using the DTS Import/Export Wizard
for a Transform Data task, View a Transform Data task
selecting, Importing Data Using the DTS Import/Export Wizard, Exporting Data Using the DTS Import/Export Wizard, Copying Objects and Data Using the DTS Import/Export Wizard
Data Driven Query task, Chapter 4: Creating Advanced DTS Tasks , Using Parameterized Queries in a Data Driven Query Task
changing the data source or binding table in, Using Parameterized Queries in a Data Driven Query Task
creating, Using Parameterized Queries in a Data Driven Query Task
determining if any rows were not inserted by, Adding Package Logging and Error Handling Steps to Packages
modifying in the UpdateProductDim package, Using Parameterized Queries in a Data Driven Query Task
testing in the UpdateProductDim package, Using Parameterized Queries in a Data Driven Query Task, Important
transaction participation supported for, Enlisting Tasks in Transactions
data file contents
retrieving values for package and task properties, Using the Dynamic Properties Task
data flow
data pump phases and, Figure 4-1: Data pump phases and data flow
data integrity violations, Important
data lineage
column-level , Saving Packages
testing, Saving Packages
data lineage information, Saving Packages
adding columns for, Saving Packages
data link connections, Using Data Link Connection Objects
implementing, Using Data Link Connection Objects
Data Link Properties dialog box
configuring the properties of a UDL file, Using Data Link Connection Objects
data load package
creating in DTS Designer, Creating a Data Load Package in DTS Designer
data loading
increasing data throughput during, View a Transform Data task
Data Mining Prediction task, Chapter 4: Creating Advanced DTS Tasks
Data Movement Application folder, Creating a New Package in DTS Designer
data movement application packages
executing from a new folder location, Executing the Data Movement Application Packages from a New Folder Location
data movement applications
adding missing dimensions and rows, Loading and Verifying Monthly Data
adding Time dimension members , Loading Historical Data
Analysis Services tasks, adding, Creating the SalesCubeProcessing Subpackage, Ensuring Execution Order and Testing the New Steps
AuditEvents table, reviewing, Loading Historical Data
browsing the Sales cube, Loading Historical Data, Loading and Verifying Monthly Data
completing, overview of, Chapter 9: Completing the Data Movement Application
config.ini, modifying, Loading and Verifying Monthly Data
copying to a new folder and executing, Executing the Data Movement Application Packages from a New Folder Location
creating, Chapter 1: Jumping into DTS
creating an audit trail of the execution history for, Chapter 8: Incorporating Error Handling into DTS Packages
creating an execution audit trail for, Creating Task and Package Logging Steps, Testing the Use of the AuditEvents Table
creating starter DTS packages, Creating a Starter DTS Package
deleting delimited text files, Resetting the Data Movement Application in the SBS_OLAP Database
deleting log files, Resetting the Data Movement Application in the SBS_OLAP Database
designing parallelism into, Calling Subpackages
dynamic reconfiguration of packages in, Chapter 6: Dynamically Configuring DTS Package Objects
entry points for customization of, Accessing the Multiphase Data Pump
execution order, Configuring User-Friendly Names and Adding Precedence Constraints to Ensure That Steps Execute in the Proper Order
fact table population, Testing the Data Movement Application with the UpdateSalesFacts Package
fact table populationn, Creating and Calling a Package That Populates the SalesFact Table
identifying the rows affected by a particular execution of, Adding Batch Control
LoadHistoricalData package, configuring, Loading Historical Data
loading historical data, Loading Historical Data
loading monthly data, Loading and Verifying Monthly Data
maintaining different generations of, Saving Packages
MasterUpdate package, executing, Loading Historical Data, Loading and Verifying Monthly Data
migrating from a development computer to production computers, Saving Packages
modularizing , Calling Subpackages
overview on operation, Chapter 10: Operating the Data Movement Application
processing the Sales cube, Loading Historical Data
resetting databases, Resetting the Data Movement Application in the SBS_OLAP Database
setting objects for dynamic configuration, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table
storing values outside of packages in, Using the Dynamic Properties Task
template for, Chapter 9: Completing the Data Movement Application
testing execution, Ensuring Execution Order and Testing the New Steps
testing packages, Testing the Data Movement Application with the UpdateSalesFacts Package, Testing the Data Movement Application with the UpdateSalesFacts Package
testing the execution of, Testing the Steps That Generate and Add the BatchID Value, Testing the Steps That Generate and Add the BatchID Value
Time dimension members, adding, Loading and Verifying Monthly Data
UpdateSalesFacts package, configuring, Loading and Verifying Monthly Data
updating data. , see updatesalesfacts package
data movement tasks, Chapter 4: Creating Advanced DTS Tasks
data pump, The Transform Data task, Chapter 4: Creating Advanced DTS Tasks
configuring exception files for any task using, Working with Exception Files
data pump phases
accessing in DTS Designer, Accessing the Multiphase Data Pump
data source
for a Data Driven Query task, Using Parameterized Queries in a Data Driven Query Task
selecting, Importing Data Using the DTS Import/Export Wizard, Exporting Data Using the DTS Import/Export Wizard, Copying Objects and Data Using the DTS Import/Export Wizard
Data Source list
selecting Text File, Importing Data Using the DTS Import/Export Wizard
data stores
connecting tasks to, Connection Objects
to which DTS can connect, Connection Objects
data transformation properties
displaying for a Transform Data task, View a Transform Data task
data transformations
implementing row-level data lineage to track, Saving Packages
data warehouse
loading historical data into, Creating a Data Load Package in DTS Designer
data warehouse tables
populating, Creating a Data Load Package in DTS Designer
data warehouse tasks, Chapter 4: Creating Advanced DTS Tasks
database maintenance tasks, Chapter 4: Creating Advanced DTS Tasks
databases
transferring between SQL Server instances, Chapter 4: Creating Advanced DTS Tasks
DataDrivenQueryTask2 object
querying through the DTS object model, Recording Completed Rows and Rows with Errors
DataPumpTask2 object
querying through the DTS object model, Recording Completed Rows and Rows with Errors
datetime data type
of SQL Server, Creating a New Package in DTS Designer
Datetime information
Transact -SQL function returning current, Importing Data Using the DTS Import/Export Wizard
DDQ task
creating the ProductBinding table for use in, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package
updating in the UpdateProductDim subpackage, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package
DDQ.bas script, Using Parameterized Queries in a Data Driven Query Task
DDQ2.bas script, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package
Default configuration
for the MasterUpdate package, Specifying Step Execution Order in the MasterUpdate Package and Testing the Package
in the global variable configuration table, Creating a Configuration Table in SQL Server
default data type
for text file data, Importing Data Using the DTS Import/Export Wizard
default file sizes
specifying for a new database, Importing Data Using the DTS Import/Export Wizard
default giConfigID value
executing the MasterUpdate package and its subpackages with, Testing Configuration Table Configurations
default Max Error Count value
for a Transform Data task, View a Transform Data task
default transformation script, Using Parameterized Queries in a Data Driven Query Task
delete branch
importance of having in each subpackage, Testing the Steps That Generate and Add the BatchID Value
logging the execution of in UpdateCustomerDim, Creating Logging Steps in the UpdateCustomerDim Package
logging the execution of in UpdateProductDim, Creating Logging Steps in UpdateProductDim Package
delete configurations
creating in the PackageGVs table, Creating Delete Configurations to Execute the Branches in the Subpackages
creating to execute branches in subpackages, Creating Delete Configurations to Execute the Branches in the Subpackages
delete or add staging data branching step
adding to the UpdateCustomerDim package, Adding Branching Steps to the UpdateCustomerDim Package
adding to the UpdateProductDim package, Adding Branching Steps to UpdateProductDim Package
Delete Or Add Staging Data step
in UpdateCustomerDim, Configuring Steps and Execution Order in the UpdateCustomerDim Package
delete phases
adding to packages, Adding Branching Steps to the UpdateSalesFacts Package, Adding Branching Steps to the UpdateSalesFacts Package
delete staging data 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
DeleteAllStagingData.cmd, Testing the Steps That Generate and Add the BatchID Value
DeleteConfigs.sql script, Creating Delete Configurations to Execute the Branches in the Subpackages
DeleteOrAdd global variable
adding to the MasterUpdate package, Adding a Branching Variable to the MasterUpdate Package
DeleteOrAddStagingData.bas script, Adding Branching Steps to the UpdateCustomerDim Package
delimited text files
dynamically configuring the location of, Using the Dynamic Properties Task
extracting data from, Creating a Data Load Package in DTS Designer
importing data from, Important
Description column
in the global variable configuration table, Creating a Configuration Table in SQL Server
descriptive names
for connection objects, Connection Objects
design sheet
creating multiple objects on, Creating a Data Load Package in DTS Designer
opening a blank, Creating a New Package in DTS Designer
resizing objects on, Connection Objects
selecting multiple items on, Precedence Constraints
Dest Error Rows check box, Working with Exception Files
destination columns
mapping parameters to, Using Parameterized Queries in a Data Driven Query Task
Destination Columns tab
in DTS Designer, Creating a Data Load Package in DTS Designer
destination database
selecting an existing, Importing Data Using the DTS Import/Export Wizard
destination exception files, Important
destination objects
specifying the dropping and recreating of existing, Copying Objects and Data Using the DTS Import/Export Wizard
Destination tab
in DTS Designer, View a Transform Data task
destination table
as the binding table, Important
changing the default name of, Importing Data Using the DTS Import/Export Wizard
changing the properties of, Importing Data Using the DTS Import/Export Wizard
constraints on, Creating a Data Load Package in DTS Designer
created by the DTS Import/Export Wizard, Importing Data Using the DTS Import/Export Wizard
schema of, View a Transform Data task
updating with each package execution, Importing Data Using the DTS Import/Export Wizard
developers
executing DTS packages through scheduled jobs, Important
dimension tables
adding the BatchID column to, Modifying SQL Server Objects to Support Batch Control
adding to the SBS_OLAP database, Creating a New Package in DTS Designer
dimension update subpackage steps
documenting the completion of, Creating Logging Steps in the MasterUpdate Package
logging information about the completion of all, Creating Logging Steps in the MasterUpdate Package
DirectCopyXform transformation name, View a Transform Data task
DisableStep property
of the Step object, Adding Branching Steps to the UpdateCustomerDim Package
Disconnected Edit feature
of DTS Designer, Connection Objects
Distributed Transaction Coordinator service
starting, Start Distributed Transaction Coordinator
Drop And Recreate Destination Table check box, Importing Data Using the DTS Import/Export Wizard, Exporting Data Using the DTS Import/Export Wizard
drop table task
failure of, Importing Data Using the DTS Import/Export Wizard
DTS (Data Transformation Services), Chapter 1: Jumping into DTS
advanced options, Chapter 5: Working with Advanced DTS Options, Working with Exception Files
converting or transforming data between heterogeneous data sources and destinations, Importing Data Using the DTS Import/Export Wizard
determining the properties of a text file, Importing Data Using the DTS Import/Export Wizard
executing tasks in parallel, Configuring Parallel Execution of Tasks
exporting data from one data source to another, Exporting Data Using the DTS Import/Export Wizard
DTS custom tasks
building, Important
DTS Designer, Chapter 2: Using DTS Designer to Build and Extend Packages
accessing data pump phases, Accessing the Multiphase Data Pump
available only from within SQL Server Enterprise Manager, Connection Objects
configuring the maximum number of concurrent tasks, Configuring Parallel Execution of Tasks
creating a data load package in, Creating a Data Load Package in DTS Designer
creating new packages, Creating a New Package in DTS Designer
defining and configuring exception files, Working with Exception Files
Disconnected Edit feature of, Connection Objects
enabling logging, Enabling Package Logging
enabling package logging and error handling, Enabling Package Logging
enabling packages to use transactions, Enabling and Configuring Transactions
increasing or decreasing the priority of a package, Configuring Execution Priority
loading packages into, Saving Packages
opening a blank design sheet, Creating a New Package in DTS Designer
opening and editing existing packages, Opening and Editing Existing Packages, Precedence Constraints
opening packages from within, Connection Objects
types of column identifiers supplied by, Saving Packages
Visual Basic generating tool in, Saving Packages
DTS Designer toolbar
Zoom icon, Connection Objects
DTS Import/Export Wizard, Chapter 1: Jumping into DTS
copying objects and data using, Copying Objects and Data Using the DTS Import/Export Wizard
exporting data using, Exporting Data Using the DTS Import/Export Wizard
importing data using, Importing Data Using the DTS Import/Export Wizard
launching, Importing Data Using the DTS Import/Export Wizard
launching from within the SQL Server Enterprise Manager management console, Importing Data Using the DTS Import/Export Wizard
DTS object model
accessing using ActiveX Script tasks, Chapter 7: Using ActiveX Script Tasks
DTS object properties
setting at run time, Chapter 4: Creating Advanced DTS Tasks
DTS package objects
dynamically configuring, Chapter 6: Dynamically Configuring DTS Package Objects, Dynamically Changing Global Variable Values in Another Package
DTS Package Properties dialog box
Advanced tab, Enabling and Configuring Transactions
DTS packages, Chapter 1: Jumping into DTS
backing up, Backing Up Packages
creating in SQL Server, Securing Packages Stored to SQL Server
creating starters , Creating a Starter DTS Package
deleting older versions of, Important
eliminating all previous versions of, Saving Packages
enabling to log execution details to SQL Server, Enabling Package Logging
executing, Importing Data Using the DTS Import/Export Wizard, Executing Packages
executing from a command prompt using specific global variables , Executing Packages
executing the most recent version of, Important
execution order, Configuring User-Friendly Names and Adding Precedence Constraints to Ensure That Steps Execute in the Proper Order, Ensuring Execution Order and Testing the New Steps
fact table population, Creating and Calling a Package That Populates the SalesFact Table, Testing the Data Movement Application with the UpdateSalesFacts Package
incorporating error handling into, Chapter 8: Incorporating Error Handling into DTS Packages, Testing the Recording of Row Processing Information
linking to meta data stored in Meta Data Services, Saving Packages
logging the activity of, Enabling Package Logging
reviewing existing, Securing Packages Stored to SQL Server
running as scheduled jobs, Executing Packages
saving, Saving Packages
saving multiple versions of, Saving Packages
securing, Securing Packages, Backing Up Packages
using the Metadata Browser to display details about, Saving Packages
DTS programming
information on, Chapter 7: Using ActiveX Script Tasks
DTS Query Designer
building a lookup query, Performing Lookup Queries in a Transform Data Task
DTS Run dialog box
displaying, Executing Packages
DTSLineage_Full identifier, Saving Packages
DTSLineage_Short identifier, Saving Packages
DTSRun batch file
creating and executing with a different giConfigID value, Testing Configuration Table Configurations
executing with different configuration values, Adding Package Logging and Error Handling Steps to Packages
DTSRun statement
copying to the clipboard, Executing Packages
generating, Executing Packages
parameters in a generated, Executing Packages
DTSRunUI
executing with, Loading Historical Data
DTSRunUI graphical utility
generating a DTSRun statement, Executing Packages
DTSTask_DTSDataPumpTask_1 task, Using the Dynamic Properties Task
DTSTransformstat_OK constant, Accessing the Multiphase Data Pump
dynamic configuration
migrating data movement applications, Using the Dynamic Properties Task
of data movement applications, Chapter 6: Dynamically Configuring DTS Package Objects
setting objects for, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table
dynamic paths
configuring for exception files, Updating Global Variable Values in the UpdateProductDim Package from the Configuration Table, Updating Exception File Location Information Dynamically for UpdateProductDim Package Tasks
Dynamic Properties task, Chapter 4: Creating Advanced DTS Tasks
configuring in the LoadHistoricalData package, Using the Dynamic Properties Task
configuring in the UpdateCustomerDim package, Using the Dynamic Properties Task
configuring to dynamically set properties in the UpdateProductDim package, Using the Dynamic Properties Task
configuring to use global variable values, Using the Dynamic Properties Task
modifying package properties at run time, Using the Dynamic Properties Task
updating in the UpdateCustomerDim package with a registry key value, Updating the Dynamic Properties Task in the UpdateCustomerDim Package with a Registry Key Value, Updating the Dynamic Properties Task in the UpdateCustomerDim Package with a Registry Key Value
updating in the UpdateProductDim package 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
updating MasterUpdate with a registry key value, Updating the Dynamic Properties Task in the MasterUpdate Package with a Registry Key Value, Updating the Dynamic Properties Task in the MasterUpdate Package with a Registry Key Value
dynamically configured data link connection
creating in the MasterUpdate package to the SBS_OLAP database, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table



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