RCP does not work with the Stored Procedure Stage

michaeld · Post by **michaeld** » Thu Jun 25, 2009 11:00 am

Hi,

Has anybody been able to get RCP working with the stored procedure stage? It doesn't have an RCP checkbox like every other stage, and when I tried to run the job then all the columns that were expected to move through RCP were dropped. There is no mention of RCP in the Connectivity Guide for Stored Procedures
[/b]

chulett · Post by **chulett** » Thu Jun 25, 2009 1:06 pm

I don't recall the Stored Procedure stage having any kind of 'pass thru' capabilities. Input columns get mapped into the proc and output is strictly driven by the proc.

michaeld · Post by **michaeld** » Fri Jun 26, 2009 8:35 am

it does allow you to pass through columns that are not part of the SP's output, but you have to explicitly define them.... no RCP. I'm trying to make a shared container utilizing it, but I'll have to take another approach.

Sreenivasulu · Post by **Sreenivasulu** » Tue Jun 30, 2009 2:43 am

Stored procedure does not have RCP capabilities. A SP call is independent and invokes a new session in itself

Regards
Sreeni

Sreenivasulu · Post by **Sreenivasulu** » Tue Jun 30, 2009 2:43 am

Stored procedure does not have RCP capabilities. A SP call is independent and invokes a new session in itself

Regards
Sreeni

michaeld · Post by **michaeld** » Tue Jun 30, 2009 12:17 pm

Well then a thumbs down to the SP stage. They should make a connector stage that allows you to execute SP as a transformation.