Chapter 6, “Containers,” covers how to use containers to do looping in SSIS and describes
how to configure each of the basic transforms.
Chapter 7, “Joining Data,” focuses on how to join systems together, whether those systems
are two flat files or database platforms. Much of the chapter is spent showing the Lookup
Transform.
Now that you know how to configure most of the tasks and transforms, Chapter 8,
“Creating an End-to-End Package,” puts it all together with a large example that lets you
try out your SSIS experience.
Chapter 9, “Scripting in SSIS,” shows you some of the ways you can use the Script task in SSIS.
Chapter 10, “Advanced Data Cleansing in SSIS,” walks through common patterns in data
cleansing and how to accomplish them in SSIS. The chapter also covers Data Quality
Services (DQS) and how to integrate it into SSIS.
Chapter 11, “Incremental Loads in SSIS,” shows you common patterns you can use to
incrementally refresh your data. It also shows you how to use and integrate Change Data
Capture (CDC) into SSIS.
Chapter 12, “Loading a Data Warehouse,” covers how to load a data warehouse from the
ground up through example. Even smaller companies now are finding that to compete they
need to make their data work for them by employing a data warehouse. In this chapter we
show how to load dimension and fact tables and some of the common issues.
Chapter 13, “Using the Relational Engine,” discusses other features in the SQL Server arsenal
that can help you build robust and high-performance ETL solutions. The SQL Server relational
database engine has many features that were designed with data loading in mind, and
as such the engine and SSIS form a perfect marriage to extract, load, and transform your data.
Chapter 14, “Accessing Heterogenous Data,” shows you how to connect to systems other
than SQL Server like Excel, XML, and web services.
Chapter 15, “Reliability and Scalability,” demonstrates how to scale SSIS and make it more
reliable. You can use the features in this chapter to show you how to make the package
restartable if a problem occurs.
Chapter 16, “Understanding and Tuning the Data Flow Engine,” explains the architecture
of the SSIS Data Flow engine in detail and how to tune your SSIS packages for maximum
efficiency.
Chapter 17, “SSIS Software Development Life Cycle,” introduces a software development
life cycle methodology to you. It speaks to how SSIS can integrate with Visual Studio Team
System.
Chapter 18, “Error and Event Handling,” discusses how to handle problems with SSIS with
error and event handling.
Chapter 19, “Programming and Extending SSIS,” shows the SSIS object model and how to
use it to extend SSIS. The chapter goes through creating your own task, and then . . .