Annotations for Precedence Constraints (ShowAnnotation property in Precedence Constraints) in SSIS

Annotations in SSIS are a great tool to add notes, comments or other descriptive information to a package. Generally, we are adding this to the control flow, data flow, and event handlers. With the help of ShowAnnotation property in Precedence Constraints we can also add to our precedence constraints as well.

Read Annotation: https://bageshkumarbagi-msbi.blogspot.com/2016/04/annotation.html

Below the given example, we have three expressions on Precedence Constraints. Seeing these we will not know the expression. Each precedence constraint references the value of a different variable in order for it to be allowed to proceed. It is a bit difficult to know the expression for all precedence constraints. It's a bit easier to see what the package is doing at a glance if the precedence constraint annotations are displayed.

   

 

For the displaying the precedence constraint annotations we need to set the ShowAnnotation properties on the precedence constraints.

Let’s see who we will set this.

   

ShowAnnotation properties we will get below options

Ø  AsNeeded

Ø  ConstraintName

Ø  ConstraintDescription

Ø  ConstraintOptions

Ø  Never

By default, the "ShowAnnotation" property on a precedence constraint is set to "AsNeeded". The canvas does show the Fx symbol which means there's an expression placed on the precedence constraint.

ConstraintName

If we select this property the constraint name will be show.

   

By default constrain name will be like constrain n. we can change it.

ConstraintDescription

If we select this property the constraint Description will be shown.

  

By default description is blank.

ConstraintOptions

If we select this property the constraint expression will be shown.

  

Never

It will disable annotations.

  

Hope this will help to package design and documentation.