DSXchange

Hi,

I am trying to read a SQL Server Stored Procedure in the following way in ODBC Connector Stage:

DECLARE @TEST int
Exec dbo.spValidateLoadProcess 'xyztable', @TEST OUTPUT
SELECT @TEST abc

Then I am getting an error as Null Arguement:pDataSetDef

Can anyone help me in accessing this procedure.

If I use the same syntax in my Quering Tool, I am able to view a column that returns the valid value.

Are you not able to use the Stored Procedure stage for this?

I will try that. But before I just tried various options with ODBC Connector. Can you please help in figuring out with ODBC stage.