DSXchange

Hi,

How to execute a SQL server stored procedure for each row. The SP has two input parameters and one output parameter.

I need to execute the SP for each row of my result set and generate an output result set.

We are on 7.5.1a version and stored procedure stage doesnt allow to execute MSSQL stored procedure.

thanks in advance!

You can execute SQL Server Stored procedure using ODBC stage. Not sure though about row by row execution.