Flylib.com
List of Figures
Previous page
Table of content
Next page
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
Previous page
Table of content
Next page
MicrosoftВ® SQL Server(TM) 2005 Integration Services Step by Step
ISBN: 0735624054
EAN: 2147483647
Year: 2007
Pages: 152
Authors:
Paul Turley
,
Joe Kasprzak
,
Scott Cameron
,
Satoshi Iizuka
,
Pablo Guzman
,
Hitachi Consulting
BUY ON AMAZON
Network Security Architectures
What Is a Security Policy?
Emerging Security Technologies
Application Evaluation
Identity Deployment Recommendations
Identity Considerations
Cisco IOS in a Nutshell (In a Nutshell (OReilly))
Command-Line Completion
Line Commands
Asynchronous Interfaces
Cable
Encrypted Tunnels
Microsoft Windows Server 2003(c) TCP/IP Protocols and Services (c) Technical Reference
Wide Area Network (WAN) Technologies
Point-to-Point Protocol (PPP)
Transmission Control Protocol (TCP) Retransmission and Time-Out
File and Printer Sharing
Internet Information Services (IIS) and the Internet Protocols
Visual Studio Tools for Office(c) Using C# with Excel, Word, Outlook, and InfoPath
Part Two. Office Programming in .NET
Working with Tables
Working with Outlook Objects
VSTO Prerequisites
Importing an XML Data File into the Mapped Document
The Oracle Hackers Handbook: Hacking and Defending Oracle
Attacking the TNS Listener and Dispatchers
Attacking the Authentication Process
Triggers
Indirect Privilege Escalation
Running Operating System Commands
Python Programming for the Absolute Beginner, 3rd Edition
Other Client-Side Tools
Oh What a Tangled Web We Weave
Registering Callback Handler Objects
Doing the Right Thing
Section A.2. Major Changes in 1.6
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies