Returning recordset using a Stored Procedure

Sreenivasulu · Post by **Sreenivasulu** » Wed Jul 15, 2009 7:07 am

Hi All,

I am calling a SP residing in Microsoft SQL Server

Can we return a recordset using a stored procedure ?

Regards
Sreeni

chulett · Post by **chulett** » Wed Jul 15, 2009 8:16 am

What does the documentation say?

Sreenivasulu · Post by **Sreenivasulu** » Thu Jul 16, 2009 4:04 am

Hi Craig

Documentation has the tabs and settings for implementing this functionality.

Will try this out and get back to you

Regards
Sreeni

harsh_cs31 · Post by **harsh_cs31** » Sun Jul 19, 2009 12:40 am

We can use the SP stage in the Parallel job, but this will be a source, we cannot use this in between.
Using this stage we can return the dataset.
Hope it helps

Sreenivasulu · Post by **Sreenivasulu** » Tue Jul 21, 2009 10:10 am

Thanks for all your inputs plus the doucmentation ..
This is working. Only thing is that it returns an additional record with value 0 denoting success. Handling this record in the transformer.

Now i Need to try getting a cursor as an output. There is a option enabled for this. Will try that out.

Regards
Sreeni