Export (0) Print
Expand All

Restore Invalid Column References Editor

Use this dialog box to restore the mappings of invalid column references. Column references can become invalid when you change the upstream component so that the column you mapped to is no longer available, or when you change the data type of a mapped column. You can set the restore option for invalid columns one by one, or apply one option to all invalid column references. The column references are grouped by input.

Invalid Input

Lists the inputs that are no longer valid.

Invalid Column References

Lists the columns from the input that are not valid.

Available Columns

Select an available column in the list or a restore option in the list.

Option

Description

<Leave as invalid column reference>

Leave the column references that are not valid. If you skip a column by using this option, the component remains in an invalid state.

<Delete invalid column references>

Delete the column references that are not valid.

Include downstream invalid column references

Select to also restore downstream column references that are not valid.

Select All

Click to select all the invalid column references.

Column mapping option for selected rows

Select a restore option in the list to apply to the selected column references.

Option

Description

<Map using column name>

Map invalid column references to available columns using column names.

<Leave as invalid column reference>

Leave the column references that are not valid. If you skip a column by using this option, the component remains in an invalid state.

<Delete invalid column reference>

Delete the column references that are not valid.

Apply

Click to apply the restore options to the selected column references.

Community Additions

ADD
Show:
© 2015 Microsoft