Stored Procedure Stage

Izack · Post by **Izack** » Tue Jan 30, 2007 10:34 pm

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

narasimha · Post by **narasimha** » Tue Jan 30, 2007 10:38 pm

It is used to execute Stored Procedures.

Izack, please search before posting, these questions are already addressed here.

Izack · Post by **Izack** » Tue Jan 30, 2007 10:42 pm

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

DSguru2B · Post by **DSguru2B** » Tue Jan 30, 2007 10:48 pm

Then I suggest you go through this post.

chulett · Post by **chulett** » Wed Jan 31, 2007 7:55 am

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.

ray.wurlod · Post by **ray.wurlod** » Wed Jan 31, 2007 3:40 pm

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.

DSguru2B · Post by **DSguru2B** » Wed Jan 31, 2007 3:41 pm

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.

DSXchange

Stored Procedure Stage

Stored Procedure Stage

Thanks

Re: Stored Procedure Stage

Re: Stored Procedure Stage

Re: Stored Procedure Stage