Microsoft SQL Server 2005 Integration Services

All medium to large companies have to deal with data being stored in a number of databases, spreadsheets and proprietary applications. Bringing all this data together into one system can be useful to analyzing the business; but can also be quite difficult to do. Integration Services is the next big bet in Microsoft's business intelligence lineup, providing you with true enterprise extract transform and load features (ETL).

Microsoft SQL Server 2005 Integration Services concentrates on providing you with real world solutions to real world problems, giving you a head start on various projects. If you are only evaluating Integration Services, you'll be able to focus on the early chapters with the option of drilling down into details in the later chapters where some of the more complex concepts will be discussed in detail. The interesting sidebars peppered throughout the book provide insight into the processes, people and decisions that yielded the final IS product.

Downloads

Sample files developed for the book in one convenient download -- Samples.zip (5.3 MB)

Additional files for the book in one convenient download -- MissingAppendices&Sample.zip (313 KB)

Related Article

SQL 2005 Web Synchronization for Merge Replication

Online Sample Chapter

Migrating from Data Transformation Services to Integration Services in SQL Server

Sample Chapter(s)

Download the sample chapter

Table of Contents

Contents at a Glance
Part I: Getting Started
    1    Welcome to SQL Server Integration Services 2005    3
    2    Setting Up Integration Services    9
    3    Migrating from DTS    19
    4    Building a Package—Quick Start    35
Part II: Integration Services Basics and Concepts
    5    The Business Intelligence Development Studio    55
    6    The Building Blocks of Integration Services    103
    7    Grouping Control Flow with Containers    113
Part III: Control Flow Services
    8    The Stock Tasks    139
    9    Using Expressions    191
    10    The Stock Connection Managers    205
    11    Logging and the Stock Log Providers    243
    12    The Venerable Variable    261
    13    Looping and Foreach Enumerators    275
Part IV: Management Services
    14    Configuring and Deploying Solutions    299
    15    Using The Script Task    331
    16    Using Source Control    353
    17    SQL Server Management Studio    367
    18    Securing Packages    389
Part V: The Data Flow Task
    19    Introducing the Data Flow Task    415
    20    The Stock Data Flow Components    423
    21    Using the Script Component    489
    22    Advanced Data Flow Transformations    507
    23    Data Flow Task Internals and Tuning    537
Part VI: Programming Integration Services
    24    Building Custom Tasks    563
    25    Building Custom Data Flow Components    621
        Index    661