Index_I


I

IDENTITY property
defining the first column in a table, Creating a Data Load Package in DTS Designer
populating the key value in dimension tables, Creating a New Package in DTS Designer
resetting with TRUNCATE, Resetting the Data Movement Application in the SBS_OLAP Database
resetting with TRUNCATE TABLE, Creating a Data Load Package in DTS Designer
IfYouSkippedChapter1.cmd batch file, Chapter 2: Using DTS Designer to Build and Extend Packages
IfYouSkippedChapter2.cmd batch file, Saving Packages
IfYouSkippedChapter3.cmd batch file, Performing Lookup Queries in a Transform Data Task
IfYouSkippedChapter4.cmd batch file, Working with Exception Files
IfYouSkippedChapter5.cmd batch file, Using Data Link Connection Objects
IfYouSkippedChapter6.cmd batch file, Setting Global Variable Values at Run Time
IfYouSkippedChapter7.cmd batch file, Adding Batch Control
indicator column
determining whether to execute an insert or an update query, Using Parameterized Queries in a Data Driven Query Task
inherited transactions
subpackages running within, Inheriting Transactions
INI file field
retrieving values for package and task properties, Using the Dynamic Properties Task
INI file location
setting from the global variable value in the MasterUpdate package, Updating the Dynamic Properties Task in the MasterUpdate Package with a Registry Key Value
setting from the global variable value in the UpdateCustomerDim package, Updating the Dynamic Properties Task in the UpdateCustomerDim Package with a Registry Key Value
setting from the global variable value in the UpdateProductDim package, Updating the Dynamic Properties Task in the UpdateProductDim Package with a Registry Key Value
INI File step
configuring properties from to execute first in the UpdateCustomerDim package, Using the Dynamic Properties Task
initialization file
creating, Using the Dynamic Properties Task
storing the path for, Reading Registry Values for Path Locations
testing the execution of, Using the Dynamic Properties Task
inner package global variables , Important, Dynamically Changing Global Variable Values in Another Package
configuring, Dynamically Changing Global Variable Values in Another Package
Inner Package Global Variables tab, Dynamically Changing Global Variable Values in Another Package
of the Execute Package Task Properties dialog box, Calling Subpackages
Insert Batch Size check box, Creating a Data Load Package in DTS Designer
Insert Batch Size text box
setting the InsertCommitSize property, Working with Exception Files
specifying the loading of data in batches, View a Transform Data task
Insert Failure subphase
of the Post Row Transform phase, Accessing the Multiphase Data Pump
INSERT INTO statement, Using Parameterized Queries in a Data Driven Query Task
Insert New Data In CustomerDim Table step
logging the failure of in the UpdateCustomerDim package, Creating Logging Steps in the UpdateCustomerDim Package
logging the success of in the UpdateCustomerDim package, Creating Logging Steps in the UpdateCustomerDim Package
Insert or Update Dimension Table step
executing after the failure of the Load ProductStage Table step, Configuring Steps and Execution Order in the UpdateProductDim Package
Insert Or Update ProductDim Table step
logging the bypass of in UpdateProductDim, Creating Logging Steps in UpdateProductDim Package
logging the failure of in UpdateProductDim, Creating Logging Steps in UpdateProductDim Package
logging the success of in UpdateProductDim, Creating Logging Steps in UpdateProductDim Package
recording rows completed and rows with errors in UpdateProductDim, Reporting Row Processing Information by UpdateProductDim Package Tasks
INSERT or UPDATE statements
avoiding termination by errors, Reporting Row Processing Information by UpdateCustomerDim Package Tasks
Insert query
adding the BatchID column to the column list, Incorporating the BatchID Value into Tasks in the UpdateProductDim Package
INSERT statements
global variables for starter packages, Creating a Starter DTS Package
insert stored procedure
creating, Incorporating the BatchID Value into Tasks in the UpdateCustomerDim Package
Insert Success subphase
of the Post Row Transform phase, Accessing the Multiphase Data Pump
Insert.txt query, Using Parameterized Queries in a Data Driven Query Task
InsertCommitSize property
setting from the Insert Batch Size box, Working with Exception Files
InsertOrUpdate column
adding to the ProductStage table, Using Parameterized Queries in a Data Driven Query Task
evaluating the value of, Using Parameterized Queries in a Data Driven Query Task
integer data type
creating a global variable with, Generating a BatchID Value, Storing It in the MasterUpdate Package, and Then Passing...
intermediate variable, Performing Lookup Queries in a Transform Data Task
interpreted scripting languages
using within ActiveX Script tasks, Chapter 7: Using ActiveX Script Tasks
invalid transformations
removing, Using Parameterized Queries in a Data Driven Query Task
IRowsetFastLoad OLEDB interface
used by a Transform Data task with the Fastload option, Important
IS NULL clause
changing = NULL to, Importing Data Using the DTS Import/Export Wizard
ITransactionJoin interface, Enlisting Tasks in 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