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
CompTIA Project+ Study Guide: Exam PK0-003
Answers to Assessment Test
IT Project Management Overview
Other Planning Processes
Project Closure
Appendix A Systems Development Life Cycle
Introducing Microsoft Office InfoPath 2003 (Bpg-Other)
Filling Out Forms
Creating Forms
Validating Form Data
Adding Views to a Template
Introducing InfoPath Form Template Projects
C++ GUI Programming with Qt 3
Getting Started
Using the Reference Documentation
Implementing the Edit Menu
Inter-Process Communication
Internationalization
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 24. Explore a 3-D Model of the Entire World
Hack 33. Georeference an Arbitrary Tourist Map
Hack 40. Plot Points on a Spinning Globe Applet
Hack 48. Accessorize Your GPS
Hacks 64-77
Programming Microsoft ASP.NET 3.5
ASP.NET Iterative Controls
Working with the File System
Creating New ASP.NET Controls
Working with Images in ASP.NET
Index
MPLS Configuration on Cisco IOS Software
Cell-Mode MPLS over ATM Overview, Configuration, and Verification
Option 3: Multi-Hop MP-eBGP Between RR and eBGP Between ASBRs
Case Study-Multi-Homed Inter-AS Provider Network
Constraint-Based Routing and Operation in MPLS TE
Command Reference
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