MCITP Administrator: Microsoft® SQL Server™ 2005 Optimization and Maintenance (70-444): Study Guide

Understanding Control Flow Items and Maintenance Plan Tasks

In the following sections, we'll conduct a very high-level review of all the containers and tasks available for use on the Control Flow tab. Some are very specialized (the Message Queue and Data Mining Query tasks), while others are likely to appear in almost every package you build (the Data Flow, Execute SQL, and Send Mail tasks).

Control Flow Items

Most of the following controls' names make their purpose easy to understand. In the following list, we describe possible uses that might help you retain their functions a bit better:

For loop container Loops through a list of items; this is less frequently used than the ForEach loop container. It has the ability to process files in any ...