|
|
Table of Contents
Part I: Getting Started
Chapter 1. Welcome to SQL Server Integration Services 2005
What Is SQL Server Integration Services?
A Short Integration Services History
What's New? (or, This Is Not Your Father's DTS!)
How This Book Is Organized
The Sample Projects
Chapter 2. Setting Up Integration Services
Installing IS
Surface Area Configuration
Setting Up Book Samples
Where Is Everything?
Helpful Resources
Summary
Chapter 3. Migrating from DTS
The Scope of Things
Available Migration Resources
Some Migration Considerations
Summary
Chapter 4. Building a PackageQuick Start
Quick Start
Summary
Part II: Integration Services Basics and Concepts
Chapter 5. The Business Intelligence Development Studio
Getting Started
The Integration Services Options
Visual Studio Standard Options
Summary
Chapter 6. The Building Blocks of Integration Services
The Building Blocks of Integration Services
The Package and Other Objects
The Data Flow Task, Adapters, and Transforms
Data Flow Versus WorkflowFundamental Differences
Summary
Chapter 7. Grouping Control Flow with Containers
The Container Concept
Scoping
Common Container Properties
Designer Groupingsthe Noncontainers
The Task and the Taskhost Container
The Looping Containers
The Package Container
Summary
Part III: Control Flow Services
Chapter 8. The Stock Tasks
Common Task Conventions
Task Groups
The Workflow Tasks
The Scripting Tasks
The Data-Processing Tasks
Summary
Chapter 9. Using Expressions
Expression Basics
Property Expressions
Data Flow Property Expressions
Variable Expressions
Precedence Constraint Expressions
For Loop Expressions
Summary
Chapter 10. The Stock Connection Managers
Connection Manager Concepts
Creating Connection Managers
Stock Connection Managers
Data Sources and Data Source Views
Summary
Chapter 11. Logging and the Stock Log Providers
The Basics
Configuring Package Logging
The Stock Log Providers
Logging Providers and Logging Options
Logging Schema
Log Events
Custom Logging
Summary
Chapter 12. The Venerable Variable
Important Variable ConceptsProperties, Scope, Type, and Namespace
System Variables
Creating and Using Variables
Execution Time Behavior
Variable Tips and Tricks
Summary
Chapter 13. Looping and Foreach Enumerators
The For Loop
The Foreach Loop
Stock Foreach Enumerators
Summary
Part IV: Management Services
Chapter 14. Configuring and Deploying Solutions
Package Configurations
The Package Configurations Organizer
Package Configuration Types
Deploying Packages
Configuration and Deployment Approaches
Summary
Chapter 15. Using the Script Task
The Script Task Environment
Using the Script Task
Script Task Samples
Summary
Chapter 16. Using Source Control
What Is Source Control?
Source Control in the Designer (BIDS)
Practices
Summary
Chapter 17. SQL Server Management Studio
SQL Server Management Studio Overview
Connecting to the Integration Services Server
Managing Packages
Using SQL Server Agent to Execute Packages
Configuring the Integration Services Server
Summary
Chapter 18. Securing Packages
Controlling Package Access
Identifying Sensitive Data
Protecting Packages and Other Files
Integrating with SQL Server Agent
Detecting Package Modification
Security Scenario Settings
Summary
Part V: The Data Flow Task
Chapter 19. Introducing the Data Flow Task
Pipeline Philosophy 101
Data Flow Terms
Data Flow Properties
Summary
Chapter 20. The Stock Data Flow Components
Common Component Conventions
Source Adapters
Flow Control Transforms
Auditing Transforms
Data Manipulation Transforms
Destination Adapters
Summary
Chapter 21. Using the Script Component
Introduction to the Script Component
Creating a Source Adapter
Creating a Destination Adapter
Creating a Transformation
Asynchronous Outputs
Summary
Chapter 22. Advanced Data Flow Transformations
The Slowly Changing Dimension Wizard and Transform (SCD)
Data Cleansing Components
Text Mining and Document Warehousing Components
Summary
Chapter 23. Data Flow Task Internals and Tuning
Data Flow Task Under the Hood
Turnkey Settings for Speedup
An Approach to Data Flow Optimization
Summary
Part VI: Programming Integration Services
Chapter 24. Building Custom Tasks
Custom Runtime Components
Starting an SSIS Custom Component Project
Developing and Debugging the Task
Building the Task User Interface
Custom Task Best Practices
Summary
Chapter 25. Building Custom Data Flow Components
Custom Component Concepts
The Sample Components
The Design Time Methods
The Runtime Methods
Writing a Source Adapter
Writing a Destination Adapter
Writing a Transform
Summary
Index |
|
楼主: tang2049
IP卡
狗仔卡
楼主
显身卡