Microsoft SQL Server 2000 DTS Step by Step (Step by Step (Microsoft))

F

fact table

adding to the SBS_OLAP database, Creating a New Package in DTS Designer

fact tables

adding new data, Creating the Steps That Load Data into the SalesStage and SalesFact Tables, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

BatchID column creation, Creating the Steps That Load Data into the SalesStage and SalesFact Tables, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

branching steps for, Adding Branching Steps to the UpdateSalesFacts Package, Adding Branching Steps to the UpdateSalesFacts Package

Bulk Insert task, Creating the Steps That Load Data into the SalesStage and SalesFact Tables, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

creating UpdateSalesFacts subpackage, Creating the Steps That Load Data into the SalesStage and SalesFact Tables, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

dynamic configuration elements, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package, Adding the Dynamic Configuration Elements to the UpdateSalesFacts Package

loading data in starter package, Creating and Calling a Package That Populates the SalesFact Table, Testing the Data Movement Application with the UpdateSalesFacts Package

steps in creating packages for, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

stored procedure for, Creating the Steps That Load Data into the SalesStage and SalesFact Tables, Creating the Steps That Load Data into the SalesStage and SalesFact Tables

failed step

double-clicking in the Executing DTS Package dialog box, Precedence Constraints

failure conditions

testing for, Accessing the Multiphase Data Pump

failure patterns

viewing, Precedence Constraints

failure precedence constraint

executing error-handling tasks , Branch upon the Success or Failure of a Transaction

file system

DTS packages stored in, Saving Packages

saving DTS packages to, Saving Packages

securing DTS packages stored in, Securing Packages Stored in the File System

file system databases, Connection Objects

File Transfer Protocol task, Chapter 4: Creating Advanced DTS Tasks

FileName property

dynamically configuring in each Execute Package task, Passing the giConfigID Value to Subpackages and Dynamically Configuring the Execute Package Tasks in the MasterUpdate ...

First Row Has Column Name check box

selecting, Importing Data Using the DTS Import/Export Wizard

folder location

executing packages from a different, Executing the Data Movement Application Packages from a New Folder Location

FOREIGN KEY constraints, Creating a New Package in DTS Designer

dropping on a table using ALTER TABLE, Creating a Data Load Package in DTS Designer

Free-Threaded model, Working with Tasks That Are Not Free-Threaded

friendly names

referring to steps in a package, Adding Branching Steps to the UpdateCustomerDim Package

F3

retrieving the last command executed, Enabling Package Logging