Flylib.com
.NODE
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
Similar book on Amazon
Oracle SQL*Plus: The Definitive Guide (Definitive Guides)
Professional SQL Server 2000 DTS (Data Transformation Services) (Programmer to Programmer)
Microsoft SQL Server 2000 DTS [Data Transformation Services]
The Guru's Guide to Transact-SQL
Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services (Wrox Programmer to Programmer)
The CISSP and CAP Prep Guide: Platinum Edition
Absolute Beginner[ap]s Guide to Project Management
15 Common Mistakes of Project Managers
Controlling a Project
Unique Aspects of Managing Project Quality
Managing Differences
Twelve Key Project Management Skills for Better Vendor Management
Certified Ethical Hacker Exam Prep
Enumeration
Key Terms
Summary
Apply Your Knowledge
Answers to Practice Exam Questions
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Cisco Secure IDS
Snort
Incident Response
Policy and Procedures
Laws, Standards, and Organizations
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hack 17. Choose a Cellular Data Plan
Hacks 4051: Introduction
Hack 63. Build Your Own Access Point with Linux
Hack 98. Align Antennas at Long Distances
Section A.10. 802.1x: Port Security for Network Communications
Professional Struts Applications: Building Web Sites with Struts ObjectRelational Bridge, Lucene, and Velocity (Experts Voice)
The Challenges of Web Application Development
Creating a Struts-based MVC Application
Form Presentation and Validation with Struts
Templates and Velocity
Creating a Search Engine with Lucene
VBScript in a Nutshell, 2nd Edition
VBScript Data Types: The Many Faces of the Variant
The Form-Based Development Environment
Program Flow
The SCRIPT Tag
Section A.11. Mathematical and Numeric
Flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy