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]
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
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.