List of Figures

Chapter 1: Introduction to SQL Server Integration Services

Figure 1-1: The SSIS data flow data pipeline

Figure 1-2: Sample SSIS components configuration scenario

Chapter 2: Building Your First Package

Figure 2-1: The SSIS development environment

Figure 2-2: Solution Explorer enables you to manage all of the objects and files in a project

Figure 2-3: The Properties pane describes the state of an item in BIDS, such as the status of all the properties for a selected object

Chapter 5: Managing Control Flow

Figure 5-1: Package control flow architecture

Chapter 6: Scripting Tasks

Figure 6-1: Script Task programming model

Figure 6-2: The Script component programming model

Chapter 10: Securing and Deploying SSIS Packages

Figure 10-1: General settings using the Execute Package Utility.

Figure 10-2: Command-line settings using the Execute Package Utility

Figure 10-3: Reporting options using the Execute Package Utility

Figure 10-4: Command-line version of the Execute Package Utility

Chapter 12: Data Warehouse Concepts

Figure 12-1: Data warehouse database diagram

Figure 12-2: Quarterly sales sums add up to the sum of sales for the year

Figure 12-3: The average of averages yields an inaccurate yearly total

Figure 12-4: Fact and dimension tables related through foreign keys

Figure 12-5: Star schema consisting of a fact and multiple dimensions

Figure 12-6: Simple snowflake schema

Chapter 13: Populating Data Warehouse Structures

Figure 13-1: Star schema model

Figure 13-2: Common data staging configuration model

Figure 13-3: Staging from multiple sources

Figure 13-4: Staggered staging model

Figure 13-5: Persisted staging model

Figure 13-6: Accumulated staging model

Figure 13-7: Chunked accumulated staging model

Figure 13-8: Multiple destination with staging model

Chapter 14: SSIS General Principles

Figure 14-1: OVAL principles of performance

Figure 14-2: Always use the SELECT statement for only the columns you need for the Lookup task

Figure 14-3: Optimizing from constrained to unconstrained processing using parallelism

Figure 14-4: Optimizing slowest component using parallelism

Figure 14-5: SSIS task naming template sample

Figure 14-6: SSIS component naming template sample

Figure 14-7: A sample SSIS report