---

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

ISBN: 0735619166
EAN: 2147483647

Year: 2003
Pages: 87

Authors: Carl Rabeler

BUY ON AMAZON

• Table of Contents
• BackCover
• Microsoft SQL Server 2000 DTS Step by Step
• Introduction
• How This Book Is Organized
• What Do I Need to Use This Book?
• How Do I Install the Practice Files?
• How Do I Obtain More Information?
• Chapter 1: Jumping into DTS
• Importing Data Using the DTS ImportExport Wizard
• Exporting Data Using the DTS ImportExport Wizard
• Copying Objects and Data Using the DTS ImportExport Wizard
• Chapter Summary
• Chapter 2: Using DTS Designer to Build and Extend Packages
• Opening and Editing Existing Packages
• Creating a New Package in DTS Designer
• Creating a Data Load Package in DTS Designer
• Chapter Summary
• Chapter 3: Working with DTS Packages
• Saving Packages
• Securing Packages
• Executing Packages
• Enabling Package Logging
• Chapter Summary
• Chapter 4: Creating Advanced DTS Tasks
• Performing Lookup Queries in a Transform Data Task
• Using Parameterized Queries in a Data Driven Query Task
• Accessing the Multiphase Data Pump
• Calling Subpackages
• Chapter Summary
• Chapter 5: Working with Advanced DTS Options
• Configuring Execution Properties
• Working with Transactions
• Working with Exception Files
• Chapter Summary
• Chapter 6: Dynamically Configuring DTS Package Objects
• Using Data Link Connection Objects
• Using the Dynamic Properties Task
• Dynamically Changing Global Variable Values in Another Package
• Chapter Summary
• Chapter 7: Using ActiveX Script Tasks
• Setting Global Variable Values at Run Time
• Reading Registry Values for Path Locations
• Enabling Package Branching
• Chapter Summary
• Chapter 8: Incorporating Error Handling into DTS Packages
• Adding Batch Control
• Creating Task and Package Logging Steps
• Recording Completed Rows and Rows with Errors
• Chapter Summary
• Chapter 9: Completing the Data Movement Application
• Creating a Starter DTS Package
• Creating and Calling a Package That Populates the SalesFact Table
• Creating the SalesCubeProcessing Subpackage
• Chapter Summary
• Chapter 10: Operating the Data Movement Application
• Resetting the Data Movement Application in the SBS_OLAP Database
• Loading Historical Data
• Loading and Verifying Monthly Data
• Chapter Summary
• Index
• Index_Numbers
• Index_A
• Index_B
• Index_C
• Index_D
• Index_E
• Index_F
• Index_G
• Index_H
• Index_I
• Index_J-K
• Index_L
• Index_M
• Index_N
• Index_O
• Index_P
• Index_Q
• Index_R
• Index_S
• Index_T
• Index_U
• Index_V
• Index_W
• Index_Z
• List of Figures