Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
PRECEDENCE CONSTRAINT EDITOR

Answered PRECEDENCE CONSTRAINT EDITOR

  • Sunday, November 25, 2012 4:53 AM
     
     
    Sign In to Vote
    0

    HI

    How do I fail a package based on precedence constraint.To be more clear please check the following precedence constraint setting.

    Evaluation Operation : Expression and Constraint

    Value : Success

    Expression :@value1 == @value2

    >Logical AND .All constraints must be evaluated to true.

    I want the package to fail if the above expression fails.

    My question is,suppose I have 2 packages(2 steps) in my job and this expression is in the first package.(Step 1)

    Will this step fail and not proceed to step 2 if the above expression is not satisfied

    When I run the package by itself the package does stop at the precedence constraint if the expression is not satisfied but in the output window it still shows as below.

    SSIS package "ADDRESS.dtsx" finished: Success.

    So just to brief , How do I give the precedence constraint settings so that if the expression fails ,the package should fail and I do not want the proceeding step in the job to execute.

    All the help is appreciated...

    Regards

    Praveen Uppath



     

All Replies

  • Sunday, November 25, 2012 5:58 AM
     
     Answered
    Sign In to Vote
    1

    Praveen,

    See if this helps.

    Add one more precedence constraint to Step 1.

    Set it the same way as the other except the 

    Expression :@value1 != @value2

    add a task that will definitely fail. (For Example: An execute Sql that has select 1/0) as a target task to this precedence.

    This will always fail the package when your expression fails.

    Hope this helps!

    Thanks,

    Ram

     
  • Sunday, November 25, 2012 10:35 AM
     
     
    Sign In to Vote
    0

    Hi Ram

    That is exactly what I did! Thx a lot for your help..:)

    Regards

    Praveen...