Home > Store

Microsoft SQL Server 2008 Integration Services Unleashed

Register your product to gain access to bonus material or receive a coupon.

Microsoft SQL Server 2008 Integration Services Unleashed

eBook (Watermarked)

  • Your Price: $38.39
  • List Price: $47.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.


  • Copyright 2009
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 0-13-264992-6
  • ISBN-13: 978-0-13-264992-6

Microsoft SQL Server Integration Services is Microsoft’s powerful platform for building enterprise-level data integration and data transformation solutions. It’s a powerful product, but it’s also complex and can be confusing if you don’t have a clear map for the journey. Microsoft SQL Server 2008 Integration Services Unleashed will be the only book you’ll need to harness the power that Integration Services provides.

Through clear, concise explanations and samples, you’ll grasp a clear understanding of working in the Integration Services environment, including how to set up stock components, how to use the various designer features, and how to gain practical knowledge on configuring, deploying, securing, and managing packages. Sample packages are provided to reinforce the discussion and quickly help you gain hands-on experience, and more complex topics such as Data Flow Task internals and tuning, advanced transformations, and writing custom components are all illustrated in easy-to-understand graphics. In addition, there are several custom tasks and transformations and two useful utilities with full source code available for you to use and study, including an ADO.NET destination, a text file encryption task, and a data profiling transform.

Detailed information on:

  • Using the powerful Integration Services tools to create solutions without the need to write lines of code
  • Creating packages programmatically or developing custom tasks via the Integration Services object
  • Building robust packages to solve common requirements
  • Securing packages for different environments
  • Using often overlooked or unknown platform features
  • Setting up all the stock components, including data flow components, tasks, Foreach enumerators, connection managers, and log providers
  • Writing robust and useful custom tasks
  • Building packages that seamlessly deploy to other environments
  • Writing custom data flow adapters and transforms
  • Using script tasks and components
  • Easily modifying configurations for multiple packages simultaneously
  • Writing a Task UI that looks just like the stock tasks
  • Tapping into the power of Integration Services for accessing heterogeneous data sources
  • Using expressions to make packages more responsive to the environment
  • Migrating your DTS packages with no stress

Sample Content

Table of Contents


PART I: Getting Started

1              What is Integration Services and why do I need it?

2              Setting Up Integration Services

3              Migrating from DTS or SSIS 2005

4              What's New in 2008?

PART II: Integration Services Basics

5              The Business Intelligence Development Studio

6              The Building Blocks of Integration Services

7              Grouping Control Flow with Containers

8              Building a Package-Quick Start

PART III: Control Flow Services

9              The Venerable Variable

10            Using Expressions

11            The Stock Tasks and Connection Managers

12            Using The Script Task

13            Using the Data Profiling Task

14            Logging and the Stock Log Providers

15            Looping and Foreach Enumerators

PART IV: Management Services

16            SQL Server Management Studio

17            Using Source Control

18 Securing Packages

PART V: The Data Flow Task

19            Introducing the Data Flow Task

20            The Stock Data Flow Components

21 The Script Component

22            Advanced Data Flow Transformations

23            Data Flow Task Internals and Tuning

PART VI: Solving Common Challenges

24            Configuring and Deploying Packages

25            Common Challenges (Tips and Tricks)

PART VII: Advanced Package Concepts and Patterns

26            Troubleshooting packages

27            Building Advanced Packages

PART VIII: Programming Integration Services

28            Building Custom Tasks

29            Building Custom Data Flow Components


Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership