SSIS Component – Data Mapping

In the Data Mapping tab, you can see exactly which columns of the data flow are used and how.

Parameter

This column specifies whether a data flow column is used within a search parameter.

Sort Key

This column specifies whether a data flow column is used within a sort key.

Matching

This column specifies whether a data flow column was created using the SQLPhonetics.NET component.

Input Column

The name of the input column within the data flow.

Output Column

The name of the output column within the data flow. The name of the output columns can be changed here. Only the output columns created by SQLPhonetics.NET cannot be renamed.

Pass Through

The parameter Pass Through can be used to remove input columns from the output of the data flow.