Wednesday, December 16, 2009

SQL Server Integration Services Tutorial - Using Expressions in P recedence Constraints

SQL Server Integration Services  training video

SSIS 2008 Training: Using Expressions in Precedence Constraints

A SQL Server Integration Services training video from the LearnItFirst the web's largest IT Training Video Library

Using Expressions in Precedence Constraints

Earlier in the course we looked at precedence constraints in SSIS.  Now we are going to cover precedence constraints further in depth, especially using expressions on precedence constraints.  In this video Scott will cover how to test if an expression evaluates to true or false using precedence constraints.

Highlights from this video:

  • What are precedence constraints?
  • Defining success and failure
  • Forcing a task to fail
  • Precedence constraint editor
  • Precedence constraint evaluation operation
    • constraint
    • expression
    • expression and constraint
    • expression or constraint
and much more

SSIS 2008 video tutorial

N.B.: This training video comes from LearnItFirst's SQL Server 2008 Integration Services video course.