Get data from stored procedures of a database
-
On the properties panel of the Data access activity, click
Configure.
The Data access configuration dialog box is displayed.
- On the Database connection list, select the process or server variable to specify the database connection string that holds the details of the relational database.
- On the Type list, select Stored procedures.
- On the Stored procedures list, select the database procedure to be used in the query. For example, to get the stored procedure for the jobs duration overrun query, select awsp_GetJobsDurationOverrun.
-
Map the parameters (members / properties) using dynamic or static
values.
It is mandatory to specify values for all the columns/parameters.
-
On the
Return resultset to,
select a variable.
At runtime, the data in the stored procedure is retrieved and appears in the respective columns of the table.
- Click OK.