Data Flow Path Editor (General Page)

 

Applies To: SQL Server 2016

Use the Data Flow Path Editor dialog box to set path properties, view column metadata, and manage the data viewers attached to the path.

Use the General node of the Data Flow Path Editor dialog box to name and describe the path, and to specify the options for path annotation.

Name
Provide a unique name for the path.

ID
The lineage identifier of the path. This property is read-only.

IdentificationString
The string that identifies the path. Automatically generated from the name entered above.

Description
Describe the path.

PathAnnotation
Specify the type of annotation to use. Choose Never to disable annotations, AsNeeded to enable annotation on demand, SourceName to automatically annotate using the value of the SourceName option, and PathName to automatically annotate using the value of the Name property.

DestinationName
Displays the input that is the end of the path.

SourceName
Displays the output that is the start of the path.

Data Flow Path Editor (Metadata Page)
Data Flow Path Editor (Data Viewers Page)
Data Flow
Use Annotations in Packages

Community Additions

ADD
Show: