Database Reference
In-Depth Information
Figure 10-17.
Verifying the column mappings
■
If you choose to create the target table yourself and specify different column names than the source, you
have to manually map each of these source and destination columns. ssIs's inbuilt column-mapping intelligence is based
on having the same column names, so if they differ, make sure you set up the column mappings correctly.
Caution
The data flow with the source and destination, along with the connection managers, should like Figure
10-18
.
