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
Inside Network Security Assessment: Guarding Your IT Infrastructure
Foundations and Principles of Security
Security and the Employee (Social Engineering)
Common Risk-Assessment Methodologies and Templates
Appendix C. Security Assessment Sample Report
Recommendations
Identifying and Managing Project Risk: Essential Tools for Failure-Proofing Your Project
Why Project Risk Management?
Identifying Project Schedule Risk
Managing Project Constraints and Documenting Risks
Quantifying and Analyzing Activity Risks
Monitoring and Controlling Risky Projects
Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)
Route Plan Configuration Process
Configuring Hunt Groups and Call Coverage
Review Questions
Generating a CAPF Report
Video Call Concepts
The Java Tutorial: A Short Course on the Basics, 4th Edition
Code Samples
Implementing Nested Classes
Using the Timer and TimerTask Classes
Overview of Applets
Path Help
Service-Oriented Architecture (SOA): Concepts, Technology, and Design
Orchestration
Choreography
Security
Common principles of service-orientation
Introduction to service-oriented analysis
.NET System Management Services
.NET Framework and Windows Management Instrumentation
Using the System.Management Namespace
Instrumenting .NET Applications with WMI
The WMI Schema
WMI Providers
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