Issue in Reading a SQL Server Stored Procedure

kiran0435 · Post by **kiran0435** » Mon Jun 30, 2014 11:19 am

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.

chulett · Post by **chulett** » Mon Jun 30, 2014 2:02 pm

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

kiran0435 · Post by **kiran0435** » Mon Jun 30, 2014 2:54 pm

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