Microsoft SQL Server 2000 DTS Step by Step (Step by Step (Microsoft))
S
Sales By Category view
copying from the SBS_OLTP database, Importing Data Using the DTS Import/Export Wizard
Sales cubes
browsing with Analysis Manager, Loading Historical Data, Loading and Verifying Monthly Data
data movement applications, processing in, Loading Historical Data
SalesCubeProcessing package, Creating the SalesCubeProcessing Subpackage, Ensuring Execution Order and Testing the New Steps
SalesFact table
editing data lineage columns to, Saving Packages
generating a result set to populate, Creating a Data Load Package in DTS Designer
loading historical data, Loading Historical Data
SalesFact tables
populating, Creating and Calling a Package That Populates the SalesFact Table, Testing the Data Movement Application with the UpdateSalesFacts Package
SalesFactDataDestination connection
creating, Creating a Data Load Package in DTS Designer
selecting as the data destination, Creating a Data Load Package in DTS Designer
SalesFactDataDestination connection object
modifying to use the SBS_OLAP.udl file, Using Data Link Connection Objects
Save DTS Package check box, Importing Data Using the DTS Import/Export Wizard
Save DTS Package dialog box
displaying, Creating a New Package in DTS Designer
SBS_OLAP AdditionalConnection connection
modifying to use the SBS_OLAP.udl file, Using Data Link Connection Objects
SBS_OLAP database
adding tables to, Creating a New Package in DTS Designer
connection object defining the connection properties to, Connection Objects
connection objects defining connections to, Connection Objects
creating, Importing Data Using the DTS Import/Export Wizard
creating a connection object to, Creating a New Package in DTS Designer
creating a dynamically configured data link connection in the MasterUpdate package, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table
creating a global variable configuration table, Creating a Configuration Table in SQL Server
creating connection objects to, Creating a Data Load Package in DTS Designer
creating tasks to load historical data into, Creating a Data Load Package in DTS Designer
creating the CountryCodes lookup table, Performing Lookup Queries in a Transform Data Task
deleting all staging data in the ProductStage and CustomerStage tables, Creating Delete Configurations to Execute the Branches in the Subpackages
expanding in the Metadata Browser, Saving Packages
inserting data into the ProductDim table in, Creating a Data Load Package in DTS Designer
loading data into the SalesStage table of, Creating a Data Load Package in DTS Designer
populating the TimeDim table, Creating a New Package in DTS Designer
SBS_OLAP.udl file
configuring, Using Data Link Connection Objects
storing the location of in a global variable in UpdateCustomerDim, Reporting Row Processing Information by UpdateCustomerDim Package Tasks
storing the location of in a global variable in UpdateProductDim, Reporting Row Processing Information by UpdateProductDim Package Tasks
SBS_OLAPAdditionalConnection connection, Creating a Data Load Package in DTS Designer
creating, Creating a Data Load Package in DTS Designer
selecting as the data source, Creating a Data Load Package in DTS Designer
SBS_OLAPAdditionalConnection connection object
dynamically configuring the location of the UDL file used by, Using the Dynamic Properties Task
modifying to use the SBS_OLAP.udl file, Using Data Link Connection Objects
SBS_OLAPDestination connection
configuring, Creating a New Package in DTS Designer
SBS_OLAPDestination connection object
modifying to use the SBS_OLAP.udl file, Using Data Link Connection Objects
SBS_OLTP database
connecting to, Importing Data Using the DTS Import/Export Wizard
copying data from, Exporting Data Using the DTS Import/Export Wizard
creating connection objects to, Creating a Data Load Package in DTS Designer
defining connection properties to, Connection Objects
extracting data from tables in, Creating a Data Load Package in DTS Designer
selecting as the data source, Copying Objects and Data Using the DTS Import/Export Wizard
tasks extracting data from tables in, Creating a Data Load Package in DTS Designer
SBS_OLTP.udl file
configuring, Using Data Link Connection Objects
SBSOLAP_AdditionalConnection connection, Reporting Row Processing Information by UpdateProductDim Package Tasks
Scan All Referenced Catalogs Into Repository
clicking, Saving Packages
scanning option
in Meta Data Services, Saving Packages
scheduled jobs
running DTS packages as, Executing Packages
scheduled SQL Server Agent job
creating, Executing Packages
script file
loading a query from, Importing Data Using the DTS Import/Export Wizard
Script File Directory text box, Copying Objects and Data Using the DTS Import/Export Wizard
scripts
generating in Unicode, Important
Select Objects dialog box
displaying, Copying Objects and Data Using the DTS Import/Export Wizard
Select Package dialog box, Connection Objects
expanding LoadHistoricalData in, Saving Packages
Selected Columns list
in Query Builder, Importing Data Using the DTS Import/Export Wizard
semicolon
specifying as the column delimiter , Importing Data Using the DTS Import/Export Wizard
semicolon--delimited text file
selecting as the data source, Importing Data Using the DTS Import/Export Wizard
Send Mail task, Chapter 4: Creating Advanced DTS Tasks
sequential execution
changing to parallel, Add separate connections to the TransactionDemo package
serial execution
of tasks, ImportantTasks
Serializable isolation level, Enabling and Configuring Transactions
Service Manager
in SQL Server, Start Distributed Transaction Coordinator
set-oriented processing, Using Parameterized Queries in a Data Driven Query Task
performance benefits of, Important
SetGVs ActiveX Script task
creating, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table
SetGVs.bas script, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table
SetINIFromGV.bas script, Updating the Dynamic Properties Task in the MasterUpdate Package with a Registry Key Value
SetPropertiesFromInitializationFile step
configuring to execute first in the UpdateProductDim package, Using the Dynamic Properties Task
shared connections
to a database, Connection Objects
short identifier
supplied by DTS, Saving Packages
Show Lineage Variables As Source Columns check box, Saving Packages
Show Multi-Phase Pump In The DTS Designer check box, Accessing the Multiphase Data Pump
sort column
specifying for Bulk Insert, Creating a Data Load Package in DTS Designer
Sorted Data check box
selecting, Creating a Data Load Package in DTS Designer
source and destination error rows
recording in text files, Working with Exception Files
Source Columns tab
in DTS Designer, Creating a Data Load Package in DTS Designer
source database
copying a view from, Importing Data Using the DTS Import/Export Wizard
Source Error Rows check box, Working with Exception Files
source rowset
generating using complex stored procedures, Using Parameterized Queries in a Data Driven Query Task
source table
as the binding table, Important
Source Tables list
in Query Builder, Importing Data Using the DTS Import/Export Wizard
sp_add_dtspackage system stored procedure
revoking EXECUTE permission from the public role, Securing Packages Stored to SQL Server
sp_enum_dtspackages stored procedure
revoking EXECUTE permission from the public role, Securing Packages Stored to SQL Server
sp_get_dtspackage system stored procedure
revoking EXECUTE permission from the public role, Securing Packages Stored to SQL Server
specialized tasks, Chapter 4: Creating Advanced DTS Tasks
SQL query
consolidating and filtering data, Importing Data Using the DTS Import/Export Wizard
copying data between SQL Server databases using, Importing Data Using the DTS Import/Export Wizard
mapping the output from, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table
pasting from a saved script file, Exporting Data Using the DTS Import/Export Wizard
SQL Query Analyzer
executing a query from, Creating a New Package in DTS Designer
SQL Server
creating an audit table in, Creating an Audit Table in SQL Server
problem with multiple tasks connecting over separate connections, Test the execution of the TransactionDemo package with parallel steps
reviewing package logs and error files, Enabling Package Logging
saving DTS packages to, Saving Packages
securing DTS packages stored to, Securing Packages Stored to SQL Server
version control in packages saved to, Saving Packages
SQL Server Agent job
creating a scheduled, Executing Packages
SQL Server Agent Proxy Account
executing a package in the security context of, Executing Packages
SQL Server connection objects
viewing and modifying, Connection Objects
SQL Server databases
copying data between, Importing Data Using the DTS Import/Export Wizard
copying data between using a SQL query, Importing Data Using the DTS Import/Export Wizard
copying data to Excel worksheets, Exporting Data Using the DTS Import/Export Wizard
copying Microsoft Access data to, Importing Data Using the DTS Import/Export Wizard
copying text file data to, Importing Data Using the DTS Import/Export Wizard
creating a new, Importing Data Using the DTS Import/Export Wizard
creating new connection objects to, Creating a New Package in DTS Designer
creating objects in, The Execute SQL Task
updating objects in, The Execute SQL Task
SQL Server Enterprise Manager
starting, Connection Objects
viewing package logs, Adding Package Logging and Error Handling Steps to Packages
SQL Server Enterprise Manager console
launching DTS Import/Export Wizard from, Importing Data Using the DTS Import/Export Wizard
SQL Server instances
pointing a UDL file to a specific, Using Data Link Connection Objects
transferring objects between, Copying Objects and Data Using the DTS Import/Export Wizard
using separate connections to, Plan Carefully When Executing Package Steps in Parallel
SQL Server objects
copying between databases, Chapter 4: Creating Advanced DTS Tasks
modifying to support batch control, Modifying SQL Server Objects to Support Batch Control
SQL Server objects and data
copying between SQL databases, Copying Objects and Data Using the DTS Import/Export Wizard
SQL Server Service Manager
starting the Distributed Transaction Coordinator, Start Distributed Transaction Coordinator
SQL Server 2000 databases
copying objects and data between, Copying Objects and Data Using the DTS Import/Export Wizard
SQL Server 2000 OLE DB Scanner
accessing, Saving Packages
SQL statement
configuring to generate a null result set, Adding Branching Steps to the UpdateCustomerDim Package
verifying the successful parsing of, Creating a New Package in DTS Designer
SQL_ATT_ENLIST_IN_DTC connection attribute, Enlisting Tasks in Transactions
SQL_DTS_SBS_1.1 package, Connection Objects
reviewing a Transform Data task in, View a Transform Data task
reviewing the Execute SQL tasks in, View an Execute SQL task
selecting, Connection Objects
viewing and modifying precedence constraints, Precedence Constraints
SQL_DTS_SBS_1.3 package
opening and reviewing, Connection Objects
SQL_DTS_SBS_1.4 DTS package
opening, Connection Objects
SQL_DTS_SBS_1.5 DTS package
opening, Connection Objects
staging tables
adding data incrementally during each week, Enabling Package Branching
adding to the SBS_OLAP database, Creating a New Package in DTS Designer
eliminating all data in, Testing the Steps That Generate and Add the BatchID Value
incremental loading of, Adding Branching Steps to the UpdateSalesFacts Package
missing data, adding with, Loading and Verifying Monthly Data
purpose of, Creating and Calling a Package That Populates the SalesFact Table
StartDate global variable
defining, Creating a New Package in DTS Designer
StarterDTS package
analysis step. , see analysis services tasks
creating, Creating a Starter DTS Package
fact table population, Creating and Calling a Package That Populates the SalesFact Table, Testing the Data Movement Application with the UpdateSalesFacts Package
INSERT statements for, Creating a Starter DTS Package
logging execution property, Creating a Starter DTS Package
SalesCubeProcessing package, Creating the SalesCubeProcessing Subpackage, Ensuring Execution Order and Testing the New Steps
updating data. , see updatesalesfacts package
WHERE statements for, Creating a Starter DTS Package
Status box
in the Executing DTS Package dialog box, Precedence Constraints
step execution order
specifying in the MasterUpdate package, Specifying Step Execution Order in the MasterUpdate Package and Testing the Package, Specifying Step Execution Order in the MasterUpdate Package and Testing the Package
specifying in the UpdateCustomerDim package, Specifying Step Execution Order in the UpdateCustomerDim Package, Specifying Step Execution Order in the UpdateCustomerDim Package
specifying in the UpdateProductDim package, Specifying Step Execution Order in the UpdateProductDim Package, Specifying Step Execution Order in the UpdateProductDim Package
steps
compared to tasks, Important
joining transactions, Enlisting Tasks in Transactions
planning for parallel execution of, Plan Carefully When Executing Package Steps in Parallel
renaming to user -friendly names , Adding Branching Steps to the UpdateCustomerDim Package
stored procedure
assigning global variables for, Important
creating to populate the TimeDim table, Creating a New Package in DTS Designer
stored procedures
copying, Chapter 4: Creating Advanced DTS Tasks
creating to generate rowsets, Using Parameterized Queries in a Data Driven Query Task
generating rowsets, Using Parameterized Queries in a Data Driven Query Task
revoking public role EXECUTE permissions, Securing Packages Stored to SQL Server
using as the data source, Using Parameterized Queries in a Data Driven Query Task
structured data sources, Connection Objects
structured storage file
saving the package to, Importing Data Using the DTS Import/Export Wizard
structured storage files
effect of package modification on the size of, Using Data Link Connection Objects
saving DTS packages as, Saving Packages
version control in<$endrange, Saving Packages
version control in<$startrange, Saving Packages
structured text file
importing to a SQL Server database, Importing Data Using the DTS Import/Export Wizard
structured text files
loading a table from, Creating a Data Load Package in DTS Designer
subkey
adding to the registry, Adding a Registry Entry
subpackage global variables, Dynamically Changing Global Variable Values in Another Package
subpackage location information
adding to the Config.ini initialization file, Passing the giConfigID Value to Subpackages and Dynamically Configuring the Execute Package Tasks in the MasterUpdate ...
reading into the MasterUpdate package from the Config.ini initialization file, Passing the giConfigID Value to Subpackages and Dynamically Configuring the Execute Package Tasks in the MasterUpdate ...
subpackages
adding a bypass branch to each, Enabling Package Branching
calling, Calling Subpackages
controlling the number executed simultaneously , Configuring Parallel Execution of Tasks
creating delete configurations to execute branches in, Creating Delete Configurations to Execute the Branches in the Subpackages
determining the success or failure of, Testing Configuration Table Configurations
inheriting parent package transactions, Inheriting Transactions
passing global variable values to, Calling Subpackages
passing the giBatchID global variable to, Generating a BatchID Value, Storing It in the MasterUpdate Package, and Then Passing...
transaction rollbacks in, Inheriting Transactions
using separate global variables for, Dynamically Changing Global Variable Values in Another Package
sysdtspackages table, Securing Packages Stored to SQL Server
saving DTS packages to, Saving Packages
System variable
retrieving values for package and task properties, Using the Dynamic Properties Task