Creating Auto Links Between Source And Target Fields

  1. In the Workbench, click Auto Link. The Auto Link Settings dialog box appears.
  2. Select whether you want to link fields with exact name matches or with fuzzy name matches.
  3. Click OK. A message box appears with a summary of the links made.
  4. Click OK. The message box closes.
  5. 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.

See also

Confirming Auto Linked Fields

Symbols and Fonts in the Target Pane

Making Changes to the Target Connection

Modifying your Source configuration

Viewing Field Properties