Introduction

There are many components that made SSIS a powerful tool for data integration. The objects in SSIS known as Tasks can be found under the Control Flow tab in the SSIS Toolbox and they are usually referred to as Tasks or Control Flow Tasks. The Control Flow Tasks consist of a wide variety of operations, from a simple File System Task that moves files, to XML Tasks such as XSLT or XPath that work with XML data in different ways.

Control Flow Tasks are categorized into sections; re-organizing them is simple (refer to Getting started with SSDT recipe in Chapter 1, Getting Started with SQL Server Integration Services). Each task has an editor; which is a graphical user interface that is useful for SSIS Developers. Some of the most important properties of a Task can be configured in its editor.

A good SSIS Developer should be familiar with the use of all Control Flow Tasks and use them in appropriate situations. In this chapter you will see an example of each Control Flow Task with...