Database Reference
In-Depth Information
Mappings Page
The Mappings page allows you to dictate which input columns are mapped to which destination output columns.
SSIS automatically maps the input and destinations for you if the names of both source and destination columns
are the same. If you use column aliases SQL code, as we did, the column names will be the same. If, on the other
hand, the column names are not the same, you have to map them manually.
Mapping the input and destination columns is an easy process. Just drag and drop the available input
columns in the table to destination columns. Another option is to use the dropdown box to select an input
column and an associated destination column (Figure
8-16
).
Figure 8-16.
The Mappings page
You do not have to map input columns to all destination columns. If you have more input columns than you
have destination columns, set the input column to < ignore>, thus excluding columns from the output.
