Follow-On Topics

Related Topics

# Adding a Database Query (OLEDB) Task Step

Even though the Database Query (OLEDB) tool is found under two different tool categories, they do not affect the functionality of the tool.

To add a new Database Query (OLEDB) step to an existing task, do the following:

1. Open the relevant task (for creating new tasks, see Creating a New Task).
2. Either:

|  | Click and drag the Database Query (OLEDB) icon from the Task Browser to the task Design area.

|  | Click on the Environment tab in the Task Browser. Right-click on Steps and select New > then either Data Connectors > Database Query (OLEDB) or Input > Database Query (OLEDB).

|  | From the task's Design tab, right-click on empty space and select New > then either Data Connectors > Database Query (OLEDB) or Input > Database Query (OLEDB).

3. In the General tab, enter a Name and Description for the step, and select a database connection from the drop-down list.
4. Select the Query tab. Tables for the selected database are displayed in the OLEDB Schema area.
5. Double-click on a table to display the nested columns then drag and drop the required columns into the Columns area in the Design Tab.
6. Add columns to other areas to filter and sort the query results. See Query tab for more details.
7. Select the Options tab and choose the required error options.
8. Click the Execute button in the toolbar to run the query and display the data returned in the Results tab.
9. Click OK to save the new step and close the dialog box. An icon for the Step is displayed on the Task Plan.

Copyright © 2018 Quadrant Software B.V. All rights reserved.