Path Annotation in data flow task in SSIS

 In control flow one task is link with the line that like called precedence constrain.

Read: Precedence Constraints in SSIS

https://bageshkumarbagi-msbi.blogspot.com/2016/05/precedence-constraints-in-ssis.html

Read: Annotation

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

In the data flow task one transformation is a link with a link that is called linked line.

  

If we want to show the text on the link line we need to set the property of that line.   

By default PathAnnotation value is AsNeeded.

 

Ø  AsNeeded

Ø  SourceName

Ø  PathName

Ø  Never

Ø  IDs

The “PathAnnotation” property is set to “AsNeeded” and by default,

Source Name: 

it displays the “Source Name” property. We can’t change the “Source Name” property, it is read only. But we can change the “Name” property though.  

If we change the name of this property it will not show on the line.

 

Path Name:

When we select the Path Name, the name will show the link line. 

Never:

If we select the property as Never we will not see anything on link line.   

Ids:

If we select the Ids we will show the ids of the link.  

Basically if we are using the path annotation then it is easy to understand the package transformation flow.