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

Precedence Constraints: how to control the flow of task execution

Precedence Constraints are arrows in the Control Flow which define execution priority of tasks and other executables in the Control Flow. In the samples of this book till now we used simple Precedence Constraints a lot.

In this recipe, we will explore a new way of using Precedence Constraints and we will implement an if condition in the Control Flow with Precedence Constraints.

Also, we will reveal options to work when there are multiple Precedence Constraints for each executable.

How to do it...

  1. Create a SSIS project and name it as R06_Precedence Constraints.
  2. Create a RecordCount package variable of type int32. Set the default value to 0.
  3. Add an Execute SQL Task into the Control Flow ...

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