Hi All,
I am calling a SP residing in Microsoft SQL Server
Can we return a recordset using a stored procedure ?
Regards
Sreeni
Returning recordset using a Stored Procedure
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
-
- Participant
- Posts: 9
- Joined: Fri Jul 17, 2009 11:42 am
We can use the SP stage
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
Using this stage we can return the dataset.
Hope it helps
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 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
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