You are here:

Configuring Target Steps

After you have added your connections for this DTS and configured the source connection, you can begin to configure the target steps.

A step is an operation performed on a target data object.
Steps are performed once for each source row.
One or more steps are necessary for each job.
Steps are displayed in the Step Order pane of the Configure Steps dialog box, and are performed in the listed order.

To Configure Target Steps

From the Workbench main window, click Configure Steps.
- If you are creating a new DTS, the Data Objects tab opens in the Configure Steps dialog box.
- If you are reopening the Configure Steps dialog box, the Flow Control tab displays.
Select a connection from the Connections drop-down list or click Connections to add a new connection with the Connection Manager (and then select the connection) you want.
Note: Not all connections are valid for source and target connections. For example, the same text connection cannot be both a source and a target. Only valid connections display in the Connections drop-down list.
After you select the target connection, use the Data Objects tab to select a data object for this step and the operation you want to perform on it. Select additional data objects as needed.
If required, select another connection from the Connections drop-down list and select the data object for that connection.
After you have selected the data objects and step operations, configure the steps using the remaining tabs in the Configure Steps dialog box.

Step Order Pane

The Step Order pane always displays a flowchart of the steps in this DTS. From the Step Order pane, you can make changes to the steps and step order using the following buttons:

Step	Meaning
	Move the step up.
	Move the step down.
	Copy the step. When you copy a step in the Target pane, the lookup criteria, data formulas, and data links mappings associated with step are also copied.
	Delete the step.
	Rename, modify the default step name, or add a comment to the step.
Print Step Order	Print the Step Order pane. Select a printer or the Microsoft XPS Document Writer, which allows you to save the image of the Step Order pane as an XPS file.
Add Comment, Edit Comment	Add or change a description for all the steps in this DTS. The comment appears in the DTS Report.

See the Step processing example for more information about configuring target steps.