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



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