Forum Discussion

alibaba82's avatar
alibaba82
Super Contributor
18 years ago

How to call stored procedures in a datasource step.

Hello, can you shed some light on how to call a stored procedure using the datasource step. I specified the driver, connection string. Not sure how to use the properties and SQL query. thanks A...
omatzura's avatar
omatzura
Super Contributor
18 years ago
Hi Ali,

you should be able to call the stored procedure by entering

{call ()}

in the SQL Query field and defining properties named after the columns returned (the same properties will be used for both result sets)

Currently only the first result set will be correctly returned by the datasource (a fix for this will be in 2.0.3), but the above should at least get you going with the first result set.

regards,

/Ole
eviware.com