Index_S

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