Microsoft SQL Server 2005 Integration Services Step-By-Step

Description

Teach yourself the fundamentals of SQL Server Integration Services - one step at a time. This practical, learn-by-doing tutorial delivers the guidance you need to transform and consolidate data - and build solutions that support your business intelligence needs.

Discover how to:

* Design and execute packages that transform data between files and relational databases
* Configure connection managers to access other data sources
* Create data flows that alter, split, match, and merge data
* Develop event-handlers and monitor package performance
* Encrypt sensitive information and control access to packages
* Customize script code to automate Control Flow and Data Flow tasks
* Debug, troubleshoot, and optimize packages

CD features:

* All practice exercises
* Sample databases
* Fully searchable eBook

CONTENTS:

IntroductionGetting Started with Integration Services
* Chapter 1: Introduction to SQL Server Integration Services
* Chapter 2: Building Your First PackageDesigning Packages
* Chapter 3: Extracting and Loading Data
* Chapter 4: Using Data Flow Transformations
* Chapter 5: Managing Control Flow
* Chapter 6: Scripting Tasks
* Chapter 7: Debugging Packages
* Chapter 8: Managing Package ExecutionManaging Packages
* Chapter 9: Detecting and Handling Processing Errors
* Chapter 10: Securing and Deploying SSIS Packages
* Chapter 11: Optimizing SSIS PackagesApplying SSIS to Data Warehousing
* Chapter 12: Data Warehouse Concepts
* Chapter 13: Populating Data Warehouse Structures
* Chapter 14: SSIS General PrinciplesAbout the AuthorsFor Web DevelopersAdditional SQL Server Resources for Developers