Data links and lookup links can be copied between steps. This may save
time in configuring a DTS because you don't need to recreate links that
have already been created in other steps.
To copy a link
On the Data Formulas tab,
highlight the link(s) you want to copy. You can use the CTRL
key to highlight multiple links.
Right-click a selected link and click either Copy Data Link or Copy Lookup Link.
The Select Step dialog box appears.
Note: The menu
options are unavailable if there is only one step defined, or if selected
links are from differing steps.
Select the step to which you want to copy the highlighted link(s).
Click OK
to copy the link(s) to the selected step.