Export (0) Print
Expand All
Expand Minimize

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.

NoteNote

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft