Microsoft SQL Server 2005 Integration Services Step by Step

MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step

ISBN: 0735624054
EAN: 2147483647

Year: 2007
Pages: 152

Authors: Paul Turley, Joe Kasprzak, Scott Cameron, Satoshi Iizuka, Pablo Guzman, Hitachi Consulting

BUY ON AMAZON

Table of Contents
Back Cover
Microsoft SQL Server 2005 Integration Services Step by Step
Introduction
Finding Your Best Starting Point
About the Companion CD-ROM
System Requirements
Installing and Using the Sample Files
Conventions and Features in This Book
Part I: Getting Started with Integration Services
Chapter 1: Introduction to SQL Server Integration Services
Common SSIS Applications
SSIS Objects and Process Control Components
SSIS Process Control
SSIS Components
SQL Server 2000 DTS Migration
Chapter 1 Quick Reference
Chapter 2: Building Your First Package
Exploring Business Intelligence Development Studio
Using the SSIS Import and Export Wizard
Reviewing Package Elements
Testing a Package
Chapter 2 Quick Reference
Part II: Designing Packages
Chapter 3: Extracting and Loading Data
Connection Managers
Using Data Sources and Data Source Views
Chapter 3 Quick Reference
Chapter 4: Using Data Flow Transformations
Creating Data Flow in a Package
SSIS Transformations
Using Expressions in Packages
Using Data Flow Transformations
Configuring Error Output
Chapter 4 Quick Reference
Chapter 5: Managing Control Flow
Control Flow Elements
Chapter 5 Quick Reference
Chapter 6: Scripting Tasks
Understanding Scripting Tasks
Implementing a Script Task
Understanding the Script Component
Implementing the Script Component
Understanding an ActiveX Script Task
Chapter 6 Quick Reference
Chapter 7: Debugging Packages
Debugging Control Flow
Debugging Data Flow
Debugging Script Task
Chapter 7 Quick Reference
Chapter 8: Managing Package Execution
Understanding Package Configurations
Creating and Editing an XML Configuration File
Multiple Configuration Files
Using Configuration Files
Creating Multiple Configuration Files
Exploring Package Execution Options
Understanding Package Logging
Implementing Package Logging
Chapter 8 Quick Reference
Part III: Managing Packages
Chapter 9: Detecting and Handling Processing Errors
Basic Error Detection and Handling
Understanding Event Handlers
Creating Event Handlers
Maintaining Data Consistency with Transactions
Using Checkpoint Restarts
Using Checkpoints and Transactions
Chapter 9 Quick Reference
Chapter 10: Securing and Deploying SSIS Packages
Creating a Deployment Utility
Securing a Package
Role-Based Security
Deployment Options
Creating and Applying a Configuration
Executing a Deployed Package
Monitoring Package Execution and Event Logs
Chapter 10 Quick Reference
Chapter 11: Optimizing SSIS Packages
SSIS Engine Overview
Memory Buffer Architecture
Execution Trees
Synchronous and Asynchronous Processing
Data Blocking
Non-blocking Transformations
Buffer Settings
Managing Parallelism
Data Source Tuning
Performance Management
Performance Management
Iterative Design Optimization
SSIS Log Reports
Chapter 11 Quick Reference
Part IV: Applying SSIS to Data Warehousing
Chapter 12: Data Warehouse Concepts
Data Warehouse Objectives
Data Warehouse Characteristics
Data Warehouse Fundamentals
Business Intelligence Solution Goals
Focus on Decisions
Data Granularity
Update Frequency and Persistence
Changing Dimensions
Surrogate Keys
Additive Measures
Reviewing an Operational and Database Schema
Data Warehouse System Components
Reviewing and Comparing a Data Warehouse Database Schema
Data Warehouse in Summary
Chapter 12 Quick Reference
Chapter 13: Populating Data Warehouse Structures
Data Warehouse Characteristics
Implementing Staging Tables
Types of Staging Schemes
Managing Dimension Tables Part 1
Managing Dimension Tables Part 2
Slowly Changing Dimensions
Managing Fact Tables
Chapter 13 Quick Reference
Chapter 14: SSIS General Principles
Designing SSIS Packages
Chapter 14 Quick Reference
Index
A
B
C
D
E
F
G
H
I
J
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z
List of Figures
List of Tables
List of Sidebars
CD Content