How to call a SQL Server stored procedure in ds

Jaleel · Post by **Jaleel** » Wed Feb 07, 2007 2:51 am

Could anyone please suggest how to call a SQL Server stored procedure which has no inputs and outputs?

ragunathan13 · Post by **ragunathan13** » Wed Feb 07, 2007 3:01 am

HI..

Use "stored_Procedure" stage, which is present in database palate.

srinath · Post by **srinath** » Wed Feb 07, 2007 5:08 am

USE ODBC Stage and in the general tab select stored procedure.

kumar_s · Post by **kumar_s** » Wed Feb 07, 2007 5:12 am

SIYF(Search Is Your Friend.) Simply use "SQL Server stored procedure" as keyword, you ll get many hits.

DSguru2B · Post by **DSguru2B** » Wed Feb 07, 2007 8:08 am

If it doesn not have IN or OUT parameters then you can just call it in either before or after sql tab of DRS stage.