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.