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




Microsoft SQL Server 2005 Integration Services Step by Step
MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step
ISBN: 0735624054
EAN: 2147483647
Year: 2007
Pages: 152

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net