Control Flow How-to Topics (Integration Services)

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 Integration Services 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.

Tutorial: Creating a Simple ETL Package

Task 4: Adding a Data Flow Task to the Package

Lesson 2: Adding Looping

Add, Delete, and Configure Tasks and Containers

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

How to: Set the Properties of a Task or Container

How to: Configure a Foreach Loop Container

How to: Loop through Excel Files and Tables by Using a Foreach Loop Container

How to: Configure a For Loop Container

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

How to: Map Result Sets to Variables in an Execute SQL Task

Group and Ungroup Tasks and Containers

How to: Group or Ungroup Tasks and Containers in a Control Flow

Create and Configure Precedence Constraints

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

How to: Set the Value of a Precedence Constraint by Using the Shortcut Menu

How to: Set the Properties of a Precedence Constraint

How to: Use an Expression in a Precedence Constraint

Stay Up to Date with Integration Services For the latest downloads, articles, samples, and videos from Microsoft, as well as selected solutions from the community, visit the Integration Services page on MSDN or TechNet: Visit the Integration Services page on MSDN Visit the Integration Services page on TechNet For automatic notification of these updates, subscribe to the RSS feeds available on the page.

See Also

Concepts

Control Flow Elements

Designing and Implementing Packages: How-To Topics