which stage to use for Stored Procedure

ds_ashish · Post by **ds_ashish** » Sat Jan 13, 2007 1:00 am

Hi All,

Using DS 7.5.1.A

I want to use a stored proc. which is written in MSSQL, my questions are :-

1) which stage should i use for this?
2) I have a requirement that i have to set 3 parameters as input and it retuns two output parameters. How to implement this conditions.

Please help me out from this...

DSguru2B · Post by **DSguru2B** » Sat Jan 13, 2007 1:26 am

You have STP stage in your version. Use that stage. Send in your parameters as input and specify two columns as output. Read the documentation for more info.

ds_ashish · Post by **ds_ashish** » Sat Jan 13, 2007 1:55 am

you mean to say stored procedure stage?

Or STP stage is a different stage.

i'm using DS 7.5.1.A and i have to access MSSQL stored proc.

DSguru2B · Post by **DSguru2B** » Sat Jan 13, 2007 2:04 am

Yes the Stored Procedure Stage. But wait, I dont think STP stage supports SqlServer. Use the ODBC stage.