Configure field mapping in an SQL transformation to define how to use data from the upstream transformation in a stored procedure or function. You do not configure field mapping when the transformation processes a query.
Configure field mapping on the
tab of the
You can configure the following field mapping options:
Field Map Options
Method of mapping fields to the SQL transformation. Select one of the following options:
Manual. Manually link incoming fields to the store procedure or function's input fields. Removes links for automatically mapped fields.
Automatic. Automatically link fields with the same name. Use when all of the fields that you want to link share the same name. You cannot manually link fields with this option.
Completely Parameterized. Use a parameter to represent the field mapping. In the task, you can configure all field mappings.
Partially Parameterized. Configure links in the mapping that you want to enforce and use a parameter to allow other fields to be mapped in the mapping task. Or, use a parameter to configure links in the mapping, and allow all fields and links to display in the task for configuration.
To see more information on field mapping parameters, see
Controls the fields that appear in the
list. Show all fields, unmapped fields, or mapped fields.
Links fields with matching names. Allows you to link matching fields, and then manually configure other field mappings.
You can map fields in the following ways:
Exact Field Name.
matches fields of the same name.
matches fields with similar names. For example, if you have an incoming field
and a target field
automatically links the
field with the
You can use both Exact Field Name and Smart Map in the same field mapping. For example, use Exact Field Name to match fields with the same name and then use Smart Map to map fields with similar names.
You can undo all automapped field mappings by clicking
. To unmap a single field, select the field to unmap and click
highlights newly mapped fields. For example, when you use Exact Field Name,
highlights the mapped fields. If you then use Smart Map,
only highlights the fields mapped using Smart Map.
Additional field link options. Provides the following options:
Map selected. Links the selected incoming field with the selected stored procedure or function input field.
Unmap selected. Clears the link for the selected field.