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
-
.gif)
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