Page 1 of 1
Invoking SQL Server Stored procedure
Posted: Fri Jun 10, 2005 8:02 am
by satish_valavala
In StoredProcedure (STPPX) stage Genral tab,under Database Vendor drop down list I am seeing Oracle only.
How can I invoke a SQL Server Stored procedure through the StoredProcedure Stage.
Posted: Fri Jun 10, 2005 5:53 pm
by ray.wurlod
There is only one way using the Stored Procedure stage, and that is to be patient and wait until "they" incorporate support for SQL Server stored procedures into the stage type.
Meanwhile, you can get at recordset-handling stored procedures through the ODBC Enterprise stage or the Dynamic RDBMS (DRS) stage.
Posted: Fri Jun 10, 2005 7:36 pm
by satish_valavala
Thanks ray.
I will try with DRS.