Microsoft SQL Server 2000 DTS Step by Step (Step by Step (Microsoft))
Microsoft SQL Server 2000 DTS Step by Step (Step by Step (Microsoft))
ISBN: 0735619166
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 87
Pages: 87
Authors: Carl Rabeler
- 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
Microsoft SQL Server 2000 DTS Step by Step (Step by Step (Microsoft))
ISBN: 0735619166
EAN: 2147483647
EAN: 2147483647
Year: 2003
Pages: 87
Pages: 87
Authors: Carl Rabeler