Chapter 15. Creating Microsoft SQL Server 2008 Integration Services Packages with Business Intelligence Development Studio

In Chapter 14, we looked at the major components that make up the Microsoft SQL Server 2008 Integration Services (SSIS) platform, including packages, control flow, data flow, and more. Now we’re going to work with the primary development tool used to create Integration Services packages: Business Intelligence Development Studio (BIDS). As an Integration Services developer, you’ll spend the majority of your project time working in BIDS, so you need to understand how to use the tools that BIDS provides to work with packages.

In this chapter, we examine the SSIS tools that BIDS adds to Microsoft Visual Studio, and how each one ...

Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.