Creating Auto Links Between Source And Target Fields
In the Workbench, click Auto Link. The Auto Link Settings dialog box appears.
Select whether you want to link fields with exact name matches or
with fuzzy name matches.
Click OK. A message box appears with a summary
of the links made.
Click OK. The message box closes.
Check the auto-links to ensure
they are correct. See Confirming
Auto Linked fields.
Note: Target
fields that are already linked will be ignored by the auto link procedure.
The indicators for auto links are visible only during the session
in which you created the auto links. When you close the DTS all unconfirmed
auto links will be converted to regular data links. Therefore, be sure
to confirm all auto links before closing the DTS file.