O'Reilly logo

Microsoft SQL Server 2012 Integration Services: An Expert Cookbook by Pedro Perfeito, Reza Rad

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Containers and Precedence Constraints

by Reza Rad and Pedro Perfeito

In this chapter, we will cover:

  • Sequence Container: putting all tasks in an executable object
  • For Loop Container: looping through static enumerator till a condition is met
  • Foreach Loop Container: looping through result set of a database query
  • Foreach Loop Container: looping through files using File Enumerator
  • Foreach Loop Container: looping through data table
  • Precedence Constraints: how to control the flow of task execution

Introduction

Till now we have seen how flow of execution can be defined in the Control Flow. There are trailing arrows after each task which defines the flow of execution. These arrows are called Precedence Constraints.

Precedence Constraint defines the execution ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required