Wiley Expert SQL Server 2005 Integration Services 978-0-470-13411-5 User Manual
Product codes
978-0-470-13411-5
Figure 1-1: SSIS high-performance data pipeline
The process outlined in Figure 1-1 may be simple enough, but essentially what SSIS does is to provide the
technology to make the process efficient and scalable, and provide the functionality to handle data errors.
technology to make the process efficient and scalable, and provide the functionality to handle data errors.
This chapter reviews ETL concepts in more detail, and gets you started with an SSIS example. Before
diving into the expert level details found in the ensuing chapters, reminding you about ETL concepts
and SSIS features will help solidify the background needed before moving to the details of the SSIS
application.
diving into the expert level details found in the ensuing chapters, reminding you about ETL concepts
and SSIS features will help solidify the background needed before moving to the details of the SSIS
application.
High performance source and destination providers
Native binary file, for archiving and staging
In-memory transformations enabled by pipeline buffer architecture
Full-featured data processing logic, reducing disk I/O bottlenecks
Optimized SQL 2005 destination
Bulk Flat File data adapter
3
Chapter 1: Getting Started
04_134115 ch01.qxp 4/24/07 6:40 PM Page 3