Index_G

G

gb prefix

for naming global variables , Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

gbBypassLoadDimensionTable global variable

creating, Adding Branching Steps to the UpdateCustomerDim Package, Adding Branching Steps to UpdateProductDim Package

gbBypassPackage global variable

creating, Adding Branching Steps to the UpdateCustomerDim Package, Adding Branching Steps to UpdateProductDim Package

gbDeleteOrAdd global variable

creating, Adding a Branching Variable to the MasterUpdate Package, Adding Branching Steps to the UpdateCustomerDim Package, Adding Branching Steps to UpdateProductDim Package

GenBatchID stored procedure

creating, Modifying SQL Server Objects to Support Batch Control

passing the parameter value of MasterUpdatePackage to, Generating a BatchID Value, Storing It in the MasterUpdate Package, and Then Passing...

general error information text file

defining, Working with Exception Files

Generate BatchID step

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

logging information about, Creating Logging Steps in the MasterUpdate Package

generated step names , Adding Package Logging and Error Handling Steps to Packages

GETDATE() function, Importing Data Using the DTS Import/Export Wizard

gi prefix

for naming global variables, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

identifying a global variable, Using the Dynamic Properties Task

giBatchID global variable

adding the value of to the rowset returned by the ProductStageRowsetSP stored procedure, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package

adding to the UpdateCustomerDim package, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package

adding to the UpdateProductDim package, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package

creating, Generating a BatchID Value, Storing It in the MasterUpdate Package, and Then Passing...

passing to subpackages, Generating a BatchID Value, Storing It in the MasterUpdate Package, and Then Passing...

giBatchSize global variable

creating in the MasterUpdate package, Dynamically Changing Global Variable Values in Another Package

creating in UpdateProductDim, Using the Dynamic Properties Task

giConfigID global variable

creating, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table, Updating Global Variable Values in the UpdateProductDim Package from the Configuration Table, Updating Global Variable Values in the UpdateCustomerDim Package from the Configuration Table

modifying at run time, Testing Configuration Table Configurations

passing as an outer package global variable to subpackages, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

giConfigID global variable value

passing from the MasterUpdate package to each subpackage by updating the Execute Package tasks, Passing the giConfigID Value to Subpackages and Dynamically Configuring the Execute Package Tasks in the MasterUpdate ...

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

giMaxErrorCount global variable

creating in the MasterUpdate package, Dynamically Changing Global Variable Values in Another Package

creating in UpdateProductDim, Using the Dynamic Properties Task

setting the value of, Specifying Step Execution Order in the MasterUpdate Package and Testing the Package

global variable configuration table

creating, Creating a Configuration Table in SQL Server

updating global variable values in the MasterUpdate package, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

global variable configurations

creating in the PackageGVs table, Creating Delete Configurations to Execute the Branches in the Subpackages

global variable names

case-sensitivity of, Important

global variable values

configuring a Dynamic Properties task to use, Using the Dynamic Properties Task

dynamically changing in another package, Dynamically Changing Global Variable Values in Another Package

passing to a DTS package at run time, Executing Packages

passing to subpackages, Calling Subpackages

retrieving values for package and task properties, Using the Dynamic Properties Task

setting at run time, Setting Global Variable Values at Run Time, Adding Package Logging and Error Handling Steps to Packages

setting in the UpdateCustomerDim package, Updating Global Variable Values in the UpdateCustomerDim Package from the Configuration Table

setting in the UpdateProductDim package, Updating Global Variable Values in the UpdateProductDim Package from the Configuration Table

updating in the MasterUpdate package by creating an ActiveX Script task, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

updating in the MasterUpdate package 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

updating in the UpdateCustomerDim package from the configuration table, Updating Global Variable Values in the UpdateCustomerDim Package from the Configuration Table, Updating Global Variable Values in the UpdateCustomerDim Package from the Configuration Table

updating in the UpdateProductDim package from the configuration table, Updating Global Variable Values in the UpdateProductDim Package from the Configuration Table, Updating Global Variable Values in the UpdateProductDim Package from the Configuration Table

global variables

adding to UpdateProductDim, Adding Branching Steps to UpdateProductDim Package

assigning for a stored procedure, Important

case sensitivity of, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

changing values from the context of the master package, Chapter 6: Dynamically Configuring DTS Package Objects

creating, Creating a New Package in DTS Designer, Using the Dynamic Properties Task

creating in UpdateCustomerDim to store the file location for SBS_OLAP.udl, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

creating new, Creating a New Package in DTS Designer

creating to store the location of the SBS_OLAP.udl file, Reporting Row Processing Information by UpdateProductDim Package Tasks

creating with an integer data type, Generating a BatchID Value, Storing It in the MasterUpdate Package, and Then Passing...

gi prefix used for naming, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

mapping, Creating a New Package in DTS Designer

mapping to properties, Using the Dynamic Properties Task

naming, Important

passing the value of to subpackages, Generating a BatchID Value, Storing It in the MasterUpdate Package, and Then Passing...

storing different values for the same, Creating a Configuration Table in SQL Server

Global Variables dialog box

opening, Creating a New Package in DTS Designer

Global Variables tab

in DTS Designer, Creating a New Package in DTS Designer

go prefix

for naming global variables, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

goGVsPickedUp global variable

creating, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table, Updating Global Variable Values in the UpdateProductDim Package from the Configuration Table, Updating Global Variable Values in the UpdateCustomerDim Package from the Configuration Table

green and white directional arrow

between two tasks, Precedence Constraints

gs prefix

for naming global variables, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table

gsConfigINIPath global variable

updating in MasterUpdate from the ConfigFile subkey , Updating the Dynamic Properties Task in the MasterUpdate Package with a Registry Key Value

gsSBS_OLAP_UDL global variable

creating, Reporting Row Processing Information by UpdateProductDim Package Tasks, Reporting Row Processing Information by UpdateCustomerDim Package Tasks

GUID (Globally Unique Identifier)

assigned by DTS, Saving Packages

changing in a DTSRun batch file, Important

GUID long identifier

supplied by DTS, Saving Packages