Invoking SQL Server Stored procedure

satish_valavala · Post by **satish_valavala** » Fri Jun 10, 2005 8:02 am

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.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 10, 2005 5:53 pm

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.

satish_valavala · Post by **satish_valavala** » Fri Jun 10, 2005 7:36 pm

Thanks ray.
I will try with DRS.