-
Right-click the source table in the Sending Tables branch, then select Properties.
The same mapping information is also accessible from the Receiving Table Properties dialog at either of the following:
-
Target Tables branch below your source table
-
Receiving Tables branch of your target server
-
-
Click the Mapping tab.
-
Verify the value in the Receiving server box.
The name of your target server is displays.
-
Verify the value in the Receiving table box.
The name of your target table is displayed. If it does not (for example, because its name does not match your source table’s), select the target table from the Receiving table list.
The list includes all tables in the list of Available tables for the target server. Any table name with [M] preceding it is already mapped to a source table.
The Target Column and Source Data columns in each row display your default mapped columns (those with the same names and compatible datatypes). These paired columns also have Copy column selected in the Method column:
If you need to locate and select your target table explicitly in the Receiving table box, click Defaults on the bottom of the Mapping tab to map those columns that have the same name and compatible datatypes.
Non-mapped target table columns, those that have no corresponding source column, are displayed with no Source Data entry in the Source Data column and with NULL (not mapped) in the Method column:
