Table of Contents

Microsoft SQL Server 2005 Integration Services
By Kirk Haselden
...............................................
Publisher: Sams
Pub Date: July 21, 2006
Print ISBN-10: 0-672-32781-3
Print ISBN-13: 978-0-672-32781-0
Pages: 744

Table of Contents  | Index

		Copyright
		Foreword
		About the Author
		Acknowledgments
		We Want to Hear from You!
		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