Within the architecture, we stayed up at 20,000 feet to ensure that you have a good understanding
of how SSIS works and the core parts of the architecture. You learned about the core components of
tasks, Data Flows, transformations, event handlers, containers, and variables — all crucial concepts
that you’ll be dealing with daily in SSIS. Packages are executable programs in SSIS that contain a
collection of tasks. Tasks are individual units of work that are chained together with precedence
constraints. Lastly, transformations are the Data Flow items that change the data to the form you
request, such as sorting the data.
The next chapter describes some of the tools and wizards you have at your disposal to expedite tasks
in SSIS. Chapter 3 dives deeply into the various tasks in the SSIS Toolbox that you can use to create
SSIS workflows. In Chapter 4, you’ll learn about Data Flow Task and examine the data components
that are available for use within the Data Flow pipeline to perform the transformations in ETL.