Flylib.com
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
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
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
Building Web Applications with UML (2nd Edition)
Client-Side Risks
Discussion
Advanced Design
Logical View
Design Model
Introduction to 80x86 Assembly Language and Computer Architecture
Branching and Looping
String Operations
Bit Manipulation
Floating-Point Arithmetic
Decimal Arithmetic
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Individual change
Organizational change
Leading change
Part II - The Applications
Cultural change
GO! with Microsoft Office 2003 Brief (2nd Edition)
Objective 10. Close and Save a Database
Objective 13. Group Data and Calculate Statistics in a Query
GO! with Access Help
Key Terms
GO! with Help
InDesign Type: Professional Typography with Adobe InDesign CS2
Up Next
Keep It Consistent, Except. . .
Glyph Positioning
Nested Styles
Transparency Effects
What is Lean Six Sigma
Key #1: Delight Your Customers with Speed and Quality
Key #3: Work Together for Maximum Gain
When Companies Start Using Lean Six Sigma
The Experience of Making Improvements: What Its Like to Work on Lean Six Sigma Projects
Six Things Managers Must Do: How to Support Lean Six Sigma
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies