O'Reilly logo

Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 by Kevin S. Goff Lynn Langit Davide Mauri, Sahil Malik, and John C. Welch

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Control Flow

In this section, we take a closer look at some of the core tasks used in BI ETL scenarios. As we do this, we’ll describe different capabilities in the platform. We won’t cover the details of every task in depth, because some tasks are virtually self-documenting and we want to focus on building SSIS packages that facilitate BI ETL. So we’ll work to build a foundation in particular task capabilities in this section. To get started, we’ll work with a package that is part of the samples that are available for download from http://www.codeplex.com/MSFTISProdSamples. When you unzip the file, it creates a folder named MSFISPRodSamples-15927. Navigate to the folder named Katmai_August2008_RTM\Package Samples\ExecuteProcess Sample. The solution ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required