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
Interprocess Communications in Linux: The Nooks and Crannies
The fork System Call Revisited
exec s Minions
Creating a Message Queue
Shared Memory Class
Multiplexing I/O with select
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
Layouts
Trees
Scales, Sliders, and Progress Bars
JFace Windows and Dialogs
JFace Wizards
C & Data Structures (Charles River Media Computer Engineering)
Address and Pointers
Preprocessing
Strings
Graphs
Problems in Linked Lists
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
Why this book is important
Case Studies
How case studies are used
Integration considerations
Appendix B. Service Models Reference
Wireless Hacks: Tips & Tools for Building, Extending, and Securing Your Network
Hacks 2339: Introduction
Hack 51. Track Wireless Users
Hack 57. The NoCat Night Light
Hack 80. Redirect Brought to you by Bonjour Ads
Section A.11. WPA & 802.11i
PMP Practice Questions Exam Cram 2
Project Initiation
Answers and Explanations
Exam Prep Questions
Exam Prep Questions
Answers and Explanations
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