Calling Stored Procedure using ODBC stage

sashah · Post by **sashah** » Tue Jun 16, 2009 1:32 pm

Is it possible to call a SQL Server stored procedure in a ODBC stage that is a reference link to a transformer

vreddy1 · Post by **vreddy1** » Wed Jun 17, 2009 3:30 am

I think you can, I am using in Px, I am not sure about the Server

Ramana

ArndW · Post by **ArndW** » Wed Jun 17, 2009 3:41 am

Actually, the other way around - in PX you cannot define a reference stage to a transformer, while in server you can.

chulett · Post by **chulett** » Wed Jun 17, 2009 6:48 am

I know a stored function can be used there, not so sure about the stored procedure, though. As long as you can 'select' from the sproc in a standard sql format, then I would suppose it would work.

Sreenivasulu · Post by **Sreenivasulu** » Wed Jun 17, 2009 9:36 am

Hi

rowgenerator ----- dummy row-> storedprocedure stage

would work.

Regards
Sreeni

chulett · Post by **chulett** » Wed Jun 17, 2009 9:50 am

Attention to details, please.

First, this is a Server job question so a PX solution doesn't really help. Secondly, the question was regarding a reference link to a transformer, which means using the stored procedure in a lookup, not as a target.

DSXchange

Calling Stored Procedure using ODBC stage

Calling Stored Procedure using ODBC stage

Re: Calling Stored Procedure using ODBC stage