Index_M

M

main error file

error information recorded in, Working with Exception Files

main execution thread

having simultaneously executing tasks execute on, Test the execution of the TransactionDemo package with parallel steps

main thread

specifying the execution of tasks on, Working with Tasks That Are Not Free-Threaded

mainframe applications

interfacing with, Importing Data Using the DTS Import/Export Wizard

Mappings box

on the Column Mappings tab, Importing Data Using the DTS Import/Export Wizard

master package, Calling Subpackages

calling subpackages, Configuring Parallel Execution of Tasks

configuring to change the global variable value in a subpackage, Dynamically Changing Global Variable Values in Another Package

containing Execute Package tasks, Calling Subpackages

creating, Calling Subpackages

creating matching global variables , Dynamically Changing Global Variable Values in Another Package

master package global variables

specifying, Dynamically Changing Global Variable Values in Another Package

MasterUpdate package

adding a branching variable to, Adding a Branching Variable to the MasterUpdate Package

adding the Generate BatchID step, Generating a BatchID Value, Storing It in the MasterUpdate Package, and Then Passing...

Advanced tab of the DTS Package Properties dialog box, Enabling and Configuring Transactions

configuring precedence constraints in, Specifying Step Execution Order in the MasterUpdate Package and Testing the Package

creating, Calling Subpackages

creating an Execute SQL task to log information about the completion of all dimension update steps, Creating Logging Steps in the MasterUpdate Package

creating global variables in, Dynamically Changing Global Variable Values in Another Package

creating logging steps in, Creating Logging Steps in the MasterUpdate Package, Creating Logging Steps in the MasterUpdate Package

enabling package logging and error handling, Adding Package Logging and Error Handling Steps to Packages

ensuring execution of package steps in the proper order, Updating the Dynamic Properties Task in the MasterUpdate Package with a Registry Key Value

executing, Loading Historical Data, Loading and Verifying Monthly Data

executing from DTS Designer, Testing Configuration Table Configurations

logging information about the Generate BatchID step, Creating Logging Steps in the MasterUpdate Package

passing the giConfigID value to each subpackage, Passing the giConfigID Value to Subpackages and Dynamically Configuring the Execute Package Tasks in the MasterUpdate ...

properties of, Configuring Parallel Execution of Tasks

reading the PackageGVs configuration table into a global variable in, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

setting the INI file location, Updating the Dynamic Properties Task in the MasterUpdate Package with a Registry Key Value

specifying step execution order in, Specifying Step Execution Order in the MasterUpdate Package and Testing the Package, Specifying Step Execution Order in the MasterUpdate Package and Testing the Package

testing the execution of, Specifying Step Execution Order in the MasterUpdate Package and Testing the Package, Specifying Step Execution Order in the MasterUpdate Package and Testing the Package, Testing the Use of the AuditEvents Table

updating global variables from the configuration table, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

Workflow properties dialog box, Configuring Execution Priority

MasterUpdate packages

adding Analysis Services Processing tasks to, Restoring the Analysis Services Database and Adding an Analysis Services Processing Task

bypassing Analysis Services Processing tasks , Adding Step Bypass and Logging Steps

calling subpackages, Calling the UpdateSalesFacts Subpackage from the MasterUpdate Package, Calling the UpdateSalesFacts Subpackage from the MasterUpdate Package

cube processing, Restoring the Analysis Services Database and Adding an Analysis Services Processing Task

execution order, Ensuring Execution Order and Testing the New Steps

logging bypasses , Adding Step Bypass and Logging Steps

logging steps, Adding Step Bypass and Logging Steps

purpose of, Chapter 9: Completing the Data Movement Application

MasterUpdateDefaultConfig.cmd

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

executing, Testing the Use of the AuditEvents Table

loading data from the source files into the staging tables, Testing the Steps That Generate and Add the BatchID Value

Max Error Count value

changing, Working with Exception Files

for a Transform Data task, View a Transform Data task

MaxConcurrentSteps property

of the MasterUpdate package, Configuring Parallel Execution of Tasks

MaximumErrorCount property

configuring to be set at run time based on the value of a global variable, Using the Dynamic Properties Task

increasing, Working with Exception Files

mapping a global variable to, Using the Dynamic Properties Task

setting used for, Creating Logging Steps in the UpdateCustomerDim Package

MaximumErrors property, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package

Message Queue task, Chapter 4: Creating Advanced DTS Tasks

transaction participation supported for, Enlisting Tasks in Transactions

meta data

linking DTS packages to Meta Data Services, Saving Packages

Meta Data Services

saving DTS packages to, Saving Packages

securing DTS packages stored in, Securing Packages Stored in Meta Data Services

Metadata Browser

displaying, Saving Packages

viewing package meta data, Saving Packages

Microsoft Access connections

joining transactions not supported by, Enlisting Tasks in Transactions

Microsoft Access database

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

selecting as the data source, Importing Data Using the DTS Import/Export Wizard

Microsoft Data Link

support for joining transactions, Enlisting Tasks in Transactions

Microsoft Excel 97-2000

selecting in the Destination list, Exporting Data Using the DTS Import/Export Wizard

Microsoft SQL Server Accelerator for Business Intelligence, Creating the SalesCubeProcessing Subpackage

ModifyDefaultConfig.sql script, Specifying Step Execution Order in the MasterUpdate Package and Testing the Package

monthly data

loading for data movement, Loading and Verifying Monthly Data

MS DTC service, Important

msdb database

RepositoryUser fixed database role, Securing Packages Stored in Meta Data Services

multiphase data pump, Chapter 4: Creating Advanced DTS Tasks, Accessing the Multiphase Data Pump

accessing, Accessing the Multiphase Data Pump

phases of, Accessing the Multiphase Data Pump

multiple connection objects

using the same UDL file, Using Data Link Connection Objects

multiple table join, Creating a Data Load Package in DTS Designer

multiple transactions

transaction checkpointing for, Use Transaction Checkpointing for Multiple Transactions