Control Flow How-to Topics (Integration Services)

Switch View

Community Content

In this section

Statistics Annotations (1)

Click here to expand

Collapse All

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (October 2009)

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:

For automatic notification of these updates, subscribe to the RSS feeds available on the page.

Concepts

Control Flow Elements
Designing and Implementing Packages: How-To Topics

Help and Information

Getting SQL Server 2008 Assistance