Index_A


A

Access connection objects, Connection Objects
AccessPubsDB database
connecting to, Importing Data Using the DTS Import/Export Wizard
shared connections to, Connection Objects
ActiveX Script task, Chapter 4: Creating Advanced DTS Tasks
adding a bypass load dimension table step to UpdateProductDim, Adding Branching Steps to UpdateProductDim Package
adding a bypass package step to UpdateCustomerDim, Adding Branching Steps to the UpdateCustomerDim Package
adding a bypass package step to UpdateProductDim, Adding Branching Steps to UpdateProductDim Package
adding a delete or add staging data branching step to UpdateCustomerDim, Adding Branching Steps to the UpdateCustomerDim Package
adding a delete or add staging data branching step to UpdateProductDim, Adding Branching Steps to UpdateProductDim Package
adding to record rows completed and rows with errors by the Load ProductStage Tablestep in UpdatePr, Reporting Row Processing Information by UpdateProductDim Package Tasks
creating to add a bypass load dimension table step to UpdateCustomerDim, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package
creating to set global variables in the UpdateCustomerDim package, Updating Global Variable Values in the UpdateCustomerDim Package from the Configuration Table
creating to update the MasterUpdate package, Updating Global Variable Values in the MasterUpdate Package from the Configuration Table
joining transactions not allowed for, Enlisting Tasks in Transactions
reading the ConfigFile registry key value into MasterUpdate, Updating the Dynamic Properties Task in the MasterUpdate Package with a Registry Key Value
reading the ConfigFile registry key value into UpdateCustomerDim, Updating the Dynamic Properties Task in the UpdateCustomerDim Package with a Registry Key Value
reading the ConfigFile registry key value into UpdateProductDim, Updating the Dynamic Properties Task in the UpdateProductDim Package with a Registry Key Value
recording rows completed and rows with errors by the Insert Or Update ProductDim Table step of Upda, Reporting Row Processing Information by UpdateProductDim Package Tasks
recording rows completed and rows with errors by the Load CustomerStage Table step in UpdateCustome, Reporting Row Processing Information by UpdateCustomerDim Package Tasks
setting global variable values in the UpdateProductDim package, Updating Global Variable Values in the UpdateProductDim Package from the Configuration Table
setting INI file location from the global variable value in MasterUpdate, Updating the Dynamic Properties Task in the MasterUpdate Package with a Registry Key Value
setting the INI file location, Updating the Dynamic Properties Task in the UpdateCustomerDim Package with a Registry Key Value
setting the INI file location in UpdateProductDim, Updating the Dynamic Properties Task in the UpdateProductDim Package with a Registry Key Value
transaction checkpointing for multiple transactions, Use Transaction Checkpointing for Multiple Transactions
ActiveX Script tasks
adding functionality to packages, Chapter 7: Using ActiveX Script Tasks, Creating Delete Configurations to Execute the Branches in the Subpackages
ActiveX script transformation
creating, Performing Lookup Queries in a Transform Data Task
ActiveX scripting task
Row Transform phase available through, Accessing the Multiphase Data Pump
ActiveX scripts
accessing data pump phases, Accessing the Multiphase Data Pump
leaving changed objects without context, Chapter 7: Using ActiveX Script Tasks
placeholder tasks, Calling the UpdateSalesFacts Subpackage from the MasterUpdate Package, Calling the UpdateSalesFacts Subpackage from the MasterUpdate Package
ActiveX transformation script
determining query execution, Using Parameterized Queries in a Data Driven Query Task
AddColumnsToAuditEventsTable.sql script, Modifying the AuditEvents Table to Record Row Processing Information
AddColumnsToDimTables.sql script, Modifying SQL Server Objects to Support Batch Control
AddColumnsToSalesFactTable.sql script, Saving Packages
AddInsertOrUpdateColumn.sql script, Using Parameterized Queries in a Data Driven Query Task
AddTablesToSBS_OLAP.sql script, Creating a New Package in DTS Designer
Advanced Copy Options dialog box, Copying Objects and Data Using the DTS Import/Export Wizard
Advanced DTS Run dialog box
displaying, Executing Packages
ALTER TABLE statement
dropping foreign key constraints on a table, Creating a Data Load Package in DTS Designer
AlterCustomerDimValues.sql script, Reporting Row Processing Information by UpdateCustomerDim Package Tasks
AlterProductStageRowsetSP.sql script, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package
Always Read Properties From UDL File check box
selecting, Using Data Link Connection Objects
verifying the selection of, Using Data Link Connection Objects
Analysis Manager
browsing Sales cubes, Loading Historical Data, Loading and Verifying Monthly Data
Analysis Services Processing task, Chapter 4: Creating Advanced DTS Tasks
Analysis Services tasks, Creating a Starter DTS Package
access permissions for, Creating the SalesCubeProcessing Subpackage
adding to MasterUpdate packages, Restoring the Analysis Services Database and Adding an Analysis Services Processing Task
adding to packages, Creating the SalesCubeProcessing Subpackage, Ensuring Execution Order and Testing the New Steps
bypassing in MasterUpdate packages, Adding Step Bypass and Logging Steps
execution order, Ensuring Execution Order and Testing the New Steps
logging bypasses, Adding Step Bypass and Logging Steps
logging success or failure, Adding Step Bypass and Logging Steps
Microsoft SQL Server Accelerator for Business Intelligence, Creating the SalesCubeProcessing Subpackage
restoring databases to instances, Restoring the Analysis Services Database and Adding an Analysis Services Processing Task
testing execution, Ensuring Execution Order and Testing the New Steps
Visual Basic 6 for, Creating the SalesCubeProcessing Subpackage, Creating the SalesCubeProcessing Subpackage
anomalous results
avoiding, Plan Carefully When Executing Package Steps in Parallel
applications, Connection Objects
audit table
creating in SQL Server, Creating an Audit Table in SQL Server
audit trail
of the execution history for the data movement application, Chapter 8: Incorporating Error Handling into DTS Packages
AuditEvents table
creating, Creating an Audit Table in SQL Server
enabling rows added and rows with errors to be recorded, Modifying the AuditEvents Table to Record Row Processing Information
modifying to record row processing information, Modifying the AuditEvents Table to Record Row Processing Information
testing the use of, Testing the Use of the AuditEvents Table, Testing the Use of the AuditEvents Table
writing entries to, Creating Logging Steps in the MasterUpdate Package, Creating Logging Steps in UpdateProductDim Package
Auto Generate
clicking to regenerate to the original Transact -SQL statement, Importing Data Using the DTS Import/Export Wizard
auto-mapped transformations
reviewing, Creating a Data Load Package in DTS Designer



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