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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.