Database Reference
In-Depth Information
Figure 7-9.
Commonly used control flow items
The following list describes each of the most frequently used control flow items:
•
Annotations
: Text descriptions that can be added to your SSIS package to provide
additional clarity. (To create an annotation in an SSIS package, click anywhere on the
designer surface within the Control Flow tab and select Add Annotation from the context
menu.)
•
Data Flow Task
: Handles the importing and exporting of data.
•
Execute SQL Task
: Allows SQL commands to be sent to a database server.
•
Sequence container
: Allows tasks to be grouped into a single unit of work.
■
For more information on additional tasks, please see “what's next?” for recommended reading at the end
of this chapter.
Note
The Data Flow Tab
When working in SSIS, you soon discover that the data flow tasks are the most common tasks used on the Control
Flow designer surface. Perhaps that is why data flows are the only tasks that have their own designer surface.
