Flylib.com
MicrosoftВ® SQL Server(TM) 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
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
Systematic Software Testing (Artech House Computer Library)
An Overview of the Testing Process
Detailed Test Planning
Test Implementation
Some Final Thoughts…
Appendix C IEEE Templates
Introduction to 80x86 Assembly Language and Computer Architecture
Representing Data in a Computer
Elements of Assembly Language
Branching and Looping
Input/Output
Appendix A Hexadecimal/ASCII conversion
Competency-Based Human Resource Management
Why a Focus on Jobs Is Not Enough
Competency-Based Employee Training
Competency-Based Performance Management
Competency-Based HR Management The Next Steps
Appendix B Further Suggestions on Employee Development
The New Solution Selling: The Revolutionary Sales Process That Is Changing the Way People Sell [NEW SOLUTION SELLING 2/E]
Chapter Two Principles
Chapter Four Precall Planning and Research
Chapter Seven Diagnose Before You Prescribe
Chapter Eight Creating Visions Biased to Your Solution
Chapter Nine Selling When You re Not First
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 310 Conductors for General Wiring
Article 320 Armored Cable Type AC
Article 350 Liquidtight Flexible Metal Conduit Type LFMC
Example No. D4(b) Optional Calculation for Multifamily Dwelling
Example No. D11 Mobile Home (See 550.18)
Cultural Imperative: Global Trends in the 21st Century
Cultural Black Holes
Cognitive Processes
Culture and Globalization
Appendix A Cultural Categorization Characteristics
Appendix C National Traits
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