Page 1 of 1
Calling Stored Procedure using ODBC stage
Posted: Tue Jun 16, 2009 1:32 pm
by sashah
Is it possible to call a SQL Server stored procedure in a ODBC stage that is a reference link to a transformer
Re: Calling Stored Procedure using ODBC stage
Posted: Wed Jun 17, 2009 3:30 am
by vreddy1
I think you can, I am using in Px, I am not sure about the Server
Ramana
Posted: Wed Jun 17, 2009 3:41 am
by ArndW
Actually, the other way around - in PX you cannot define a reference stage to a transformer, while in server you can.
Posted: Wed Jun 17, 2009 6:48 am
by chulett
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.
Posted: Wed Jun 17, 2009 9:36 am
by Sreenivasulu
Hi
rowgenerator ----- dummy row-> storedprocedure stage
would work.
Regards
Sreeni
Posted: Wed Jun 17, 2009 9:50 am
by chulett
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.