Home Forums Programming SSDT SSIS precedence constraint, check my logic please RE: SSIS precedence constraint, check my logic please

  • they want it to keep going regardless of if one of the truncates fails, so I've flipped the constraints over to OR constraints.

    Not sure I'd use OR in this case.  You want them all completing.  I've used OR infrequency, usually because there are multiple paths and only one can be used based on some earlier logic.  You may simply want to change the precedence constraints to Complete, so that succeed or fail all will have to complete.

    I also still don't think this precludes putting them in the same step as I and Phil recommend.  Set the precedence to Complete as well.