Page 1 of 1
Stored Procedure Stage
Posted: Tue Jan 30, 2007 10:34 pm
by Izack
What is the use of Stored Procedure Stage and in what situation we have to use ? Adn what is the advantages of this stage to use in a job ?
Thanks guys
Posted: Tue Jan 30, 2007 10:38 pm
by narasimha
It is used to execute Stored Procedures.
Izack, please search before posting, these questions are already addressed here.
Thanks
Posted: Tue Jan 30, 2007 10:42 pm
by Izack
narasimha wrote:It is used to execute Stored Procedures.
Izack, please search before posting, these questions are already addressed here.
Alright Brow, I just become a member of this site, just 45 minutes ago. Good to know about this site Buddy...
Thanks guys
Posted: Tue Jan 30, 2007 10:48 pm
by DSguru2B
Then I suggest you go through
this post.
Re: Stored Procedure Stage
Posted: Wed Jan 31, 2007 7:55 am
by chulett
Izack wrote:In what situation we have to use ? And what is the advantages of this stage to use in a job?
IMHO - none and very few. Use it if you have to.
Re: Stored Procedure Stage
Posted: Wed Jan 31, 2007 3:40 pm
by ray.wurlod
Izack wrote:What is the use of Stored Procedure Stage ?
To invoke a stored procedure (d'oh!) for every row processed.
You can also invoke stored procedures from the Enterprise ODBC stage, but with more restrictions.
Re: Stored Procedure Stage
Posted: Wed Jan 31, 2007 3:41 pm
by DSguru2B
ray.wurlod wrote:Izack wrote:What is the use of Stored Procedure Stage ?
To invoke a stored procedure (d'oh!) for every row processed.
I cant stop laughing now.