Index_O


O

object names
enclosing in quotation marks in the generated script, Copying Objects and Data Using the DTS Import/Export Wizard
objects
copying, Chapter 1: Jumping into DTS
resizing on the design sheet, Connection Objects
ODBC data source
extracting or copying data from, Importing Data Using the DTS Import/Export Wizard
support for joining transactions, Enlisting Tasks in Transactions
OLE DB data source
configuring a UDL file to connect to, Using Data Link Connection Objects
extracting or copying data from, Importing Data Using the DTS Import/Export Wizard
OLE DB Provider for SQL Server
support for joining transactions, Enlisting Tasks in Transactions
OLE DB scanner
accessing, Saving Packages
OLEDBCommand object
generated by a Bulk Insert task, Important
On Batch Complete phase
of the multiphase data pump, Accessing the Multiphase Data Pump
On Completion precedence constraint, Precedence Constraints
activating, Using Parameterized Queries in a Data Driven Query Task
changing an On Success precedence constraint to, Precedence Constraints
deleting, Precedence Constraints
in the SQL_DTS_SBS_1.1 package, Precedence Constraints
selecting, Creating Logging Steps in the MasterUpdate Package, Creating Logging Steps in the UpdateCustomerDim Package
On Failure constraints
using to define actions for step failures, Enabling Package Logging
On Failure precedence constraint, Precedence Constraints
On Pump Complete phase
of the multiphase data pump, Accessing the Multiphase Data Pump
On Success precedence constraint, Precedence Constraints
changing to an On Completion precedence constraint, Precedence Constraints
creating, Precedence Constraints
deleting, Precedence Constraints, Change the task flow to parallel
in the SQL_DTS_SBS_1.1 package, Precedence Constraints
On Success precedence constraints
creating, Creating a Data Load Package in DTS Designer
operating data movement applications
adding missing dimensions and rows, Loading and Verifying Monthly Data
adding Time dimension members , Loading Historical Data
AuditEvents table, reviewing, Loading Historical Data
browsing the Sales cube, Loading Historical Data, Loading and Verifying Monthly Data
config.ini, modifying, Loading and Verifying Monthly Data
LoadHistoricalData package, configuring, Loading Historical Data
loading historical data, Loading Historical Data
loading monthly data, Loading and Verifying Monthly Data
MasterUpdate package, executing, Loading Historical Data, Loading and Verifying Monthly Data
overview, Chapter 10: Operating the Data Movement Application
processing the Sales cube, Loading Historical Data
resetting the database, Resetting the Data Movement Application in the SBS_OLAP Database
Time dimension members, adding, Loading and Verifying Monthly Data
UpdateSalesFacts package, configuring, Loading and Verifying Monthly Data
operating system thread
configuring the execution priority of, Configuring Execution Priority
operators
selecting in Query Builder, Importing Data Using the DTS Import/Export Wizard
out-of-order task execution, Precedence Constraints
outer package global variable
specifying giConfigID as, Passing the giConfigID Value to Subpackages and Dynamically Configuring the Execute Package Tasks in the MasterUpdate ...
outer package global variables , Important, Dynamically Changing Global Variable Values in Another Package
configuring, Dynamically Changing Global Variable Values in Another Package
Outer Package Global Variables tab, Dynamically Changing Global Variable Values in Another Package
of the Execute Package Task Properties dialog box, Calling Subpackages
owner password
for a package, Connection Objects
securing DTS packages, Securing Packages Using Passwords



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