DSXchange

Version 7.5.x includes a Stored Procedure stage, have you tried that? Or ODBC? More details, please. ... Culett, STP stage is not supporting the SQL Server stored procedure. We can use DRS stage to call stored proc and can load data into table. But in my case after extracting data from the table an...

From what stage type are you calling the stored procedure? ODBC? This would mean that you are calling the stored procedure once for each row extracted from the table, presumable expecting one row of ... Ray, I am extracting data from the table using ODBC stage ,then the next step is to call the sto...

Thanks for your reply chulet

I am using ODBC stage to extract data from the table and need to pass that
values as inputs to my stored procedure in the next step.

If i got 100 rows from the table means i need to get 100 rows as output from the stored procedure

Hi ,
Hi ,
I am trying to execute stored procedure using few input parameters getting from source table . And i need to get an output from the stored procedure. I need to pass input parameters dynamically. Is anyone can help me?

Thanks,
Nanda