Page 1 of 1
Returning recordset using a Stored Procedure
Posted: Wed Jul 15, 2009 7:07 am
by Sreenivasulu
Hi All,
I am calling a SP residing in Microsoft SQL Server
Can we return a recordset using a stored procedure ?
Regards
Sreeni
Posted: Wed Jul 15, 2009 8:16 am
by chulett
What does the documentation say?
Posted: Thu Jul 16, 2009 4:04 am
by Sreenivasulu
Hi Craig
Documentation has the tabs and settings for implementing this functionality.
Will try this out and get back to you
Regards
Sreeni
We can use the SP stage
Posted: Sun Jul 19, 2009 12:40 am
by harsh_cs31
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
Posted: Tue Jul 21, 2009 10:10 am
by Sreenivasulu
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