Page 1 of 1
How to call a SQL Server stored procedure in ds
Posted: Wed Feb 07, 2007 2:51 am
by Jaleel
Could anyone please suggest how to call a SQL Server stored procedure which has no inputs and outputs?
Posted: Wed Feb 07, 2007 3:01 am
by ragunathan13
HI..
Use "stored_Procedure" stage, which is present in database palate.
Posted: Wed Feb 07, 2007 5:08 am
by srinath
USE ODBC Stage and in the general tab select stored procedure.
Posted: Wed Feb 07, 2007 5:12 am
by kumar_s
SIYF(
Search Is Your Friend.) Simply use "SQL Server stored procedure" as keyword, you ll get many hits.
Posted: Wed Feb 07, 2007 8:08 am
by DSguru2B
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.