How to pass output of one sp as input to other sp

harithay · Post by **harithay** » Tue Nov 15, 2005 6:50 pm

Hi All,

I am running sql server stored Prcoedure using ODBC stage, with input parameters which returns output 'sequence key, return code.

i am storing its output in a sequential file.

this 'sequnce key' should go as input parameter value to second stored procedure.

how can i pass 'sequence key' value from sequential file to second stored procedure (which i am going call with ODBC).

rleishman · Post by **rleishman** » Tue Nov 15, 2005 8:01 pm

This comes up at least once-per-week. Search the forum.

ray.wurlod · Post by **ray.wurlod** » Tue Nov 15, 2005 10:50 pm

Can't you just pass the value along a link to the ODBC stage that invokes the second Stored Procedure?

harithay · Post by **harithay** » Wed Nov 16, 2005 6:14 am

Thanks Ray.

ray.wurlod wrote:Can't you just pass the value along a link to the ODBC stage that invokes the second Stored Procedure?

.

yes, i did that.

ODBC(SP1)----TRANSOFORMER---seq (first job)

seq--- transofrmer---ODBC(SP2). (second job)

After executing second SP, i need to pass its out put parameter value to third job.

after finsihing second job, i am able to load table in database. but i need to one output column to third job.

i want get resultset (return value) from SP2

How can i do that.

Thanks