Share via


Cache Transformation Editor (Mappings Page)

Use the Mappings page of the Cache Transformation Editor to map the input columns in the Cache Transform transformation to destination columns in the Cache connection manager.

Note

Each input column must be mapped to a destination column, and the column data types must match. Otherwise, Integration Services Designer displays an error message.

To learn more about the Cache Transform, see Cache Transform.

To learn more about the Cache connection manager, see Cache Connection Manager.

Options

  • Available Input Columns
    View the list of available input columns. Use a drag-and-drop operation to map available input columns to destination columns.

    You can also map input columns to destination columns using the keyboard, by highlighting a column in the Available Input Columns table, pressing the menu key, and then selecting Map Items By Matching Names.

  • Available Destination Columns
    View the list of available destination columns. Use a drag-and-drop operation to map available destination columns to input columns.

    You can also map input columns to destination columns using the keyboard, by highlighting a column in the Available Destination Columns table, pressing the menu key, and then selecting Map Items By Matching Names.

  • Input Column
    View input columns selected earlier in this topic. You can change the mappings by using the list of Available Input Columns.

  • Destination Column
    View each available destination column.

See Also

Reference

Cache Transformation Editor (Connection Manager Page)