Control Flow How-to Topics (SSIS)

This section contains procedures for working with tasks, containers, and the precedence constraints that order tasks and containers in a control flow, by using the SQL Server 2005 Integration Services (SSIS) tools that Business Intelligence Development Studio provides.

Learn How to Create Control Flow

The Integration Services Tutorial includes procedures for creating a control flow in the context of a working application that solves a real life business problem.

Creating a Simple ETL Package Tutorial

Adding a Data Flow Task to the Package

Lesson 2: Adding Looping

Add, Delete, and Configure Tasks and Containers

How to: Add a Task or a Container to a Control Flow

How to: Delete a Task or a Container from a Control Flow

How to: Set Task Properties

How to: Set Container Properties

How to: Configure a Foreach Loop Container

How to: Loop through Excel Files and Tables

How to: Configure a For Loop Container

How to: Map Query Parameters to Variables in an Execute SQL Task

Group and Ungroup Tasks and Containers

How to: Group Tasks and Containers in a Control Flow

How to: Ungroup Tasks and Containers in a Control Flow

Create and Configure Precedence Constraints

How to: Connect Tasks and Containers Using a Default Precedence Constraint

How to: Set the Precedence Constraint Value Using the Shortcut Menu

How to: Set Precedence Constraint Properties Using the Precedence Constraint Editor

How to: Set Precedence Constraint Properties in the Properties Window

How to: Add an Expression to a Precedence Constraint

See Also

Concepts

Control Flow Elements

Other Resources

Integration Services How-to Topics

Help and Information

Getting SQL Server 2005 Assistance