| Icon | Object | Definition |
|---|---|---|
 | Table | Name that displays in the Data Objects Explorer in the Configure Source/Target dialog boxes, after the Data Source created in Step 1 has been selected from the Connect to Source/Target dialog box. |
 | View | Views show tables grouped according to specific database configurations in your system. When you select a view as the source, the required tables are automatically joined. |
 | Stored Procedure | A stored procedure is a collection of SQL statements and optional control-of-flow logic (for example, if A then do this, if B, then do something else) that are compiled and stored in the database. Stored procedures can be used for a variety of purposes: fetching sets of data, reading single values, and inserting/updating/deleting data in many tables. They are re-usable, can take and return parameters, and can return information relative to their successful or failed execution. Software applications that run on top of relational databases often make use of stored procedures to handle certain complex database operations. Note: Stored procedures can be used only as targets or in source queries. Stored procedures are also used to customize the way an application interacts with a database to affect business rules or business process logic. These customizations are done by creating new stored procedures or modifying existing stored procedures that ship with an application. Insight allows you to use the business process logic already present in these stored procedures. Execute is the only operation that can be performed on a stored procedure step. When a stored procedure is selected for a target step, the parameters of the procedure are displayed in the Target pane. Data can be mapped to these parameters in the same way that data is mapped to target fields. |
 | Adapter | Adapters provide a means for the Workbench to interface with other applications. Depending on your configuration, adapters may or may not display in your Data Objects Explorer. |
 | XML | Either an XML document or schema. For more information about using XML objects as a data source, see Using XML as a Source. |
- Select another data object in the Data Objects Explorer to create another step using this connection.
- Select a new connection from the Connections drop-down menu.
- Select or clear the Show read-only data objects checkbox to toggle the display of read-only data objects.
- Select or clear the This connection can receive command line switches checkbox to specify whether you can send command-line switches to the current command.
Note: Only 1 Target connection in the DTS can have this option selected.
- When you are done, click Close to return to the main window, where the Steps pane now includes all the rows from the selected data objects.