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
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
Crystal Reports 9 on Oracle (Database Professionals)
Connectivity, Authentication, and Privileges
Oracle SQL
Oracle Advanced SELECT Options
Other Tips
Appendix A Common Issues
OpenSSH: A Survival Guide for Secure Shell Handling (Version 1.0)
Step 2.1 Use the OpenSSH Tool Suite to Replace Clear-Text Programs
Step 4.1 Authentication with Public Keys
Step 4.2 Passphrase Considerations
Step 4.4 How to Generate a Key Using PuTTY
Step 5.2 Troubleshooting Common OpenSSH Errors/Problems
Cisco IOS Cookbook (Cookbooks (OReilly))
Managing the Routers ARP Cache
Using Static Hostname Tables
Routing Over Multiple Paths with Equal Costs
Setting Up Frame Relay with Point-to-Point Subinterfaces
Using NTP to Send Periodic Multicast Time Updates
Practical Intrusion Analysis: Prevention and Detection for the Twenty-First Century: Prevention and Detection for the Twenty-First Century
Crash Course in the Internet Protocol Suite
Unauthorized Activity II
Snort
NFR Security
Laws, Standards, and Organizations
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 90 Introduction
Article 330 Metal-Clad Cable Type MC
Article 390 Underfloor Raceways
Article 504 Intrinsically Safe Systems
Example No. D3 Store Building
Junos Cookbook (Cookbooks (OReilly))
Controlling Root Authentication
Using Digital Certificates to Create Dynamic IPSec SAs
Creating a Simple Firewall Filter that Matches Packet Contents
RIP
Viewing the IS-IS Link-State Database
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