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



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