Stored Proc having temp tables

_chamak · Post by **_chamak** » Thu Oct 31, 2013 9:57 am

I have an extract job which reads it from SQL Server and loads into a Dataset. We are using ODBC stage for reading the SQL server. We are calling a simple stored proc from ODBC and it works fine, now when we have temp tables in the stored proc its getting aborted with no reason. It says columns not found. We checked for the access and everything looks fine. Not able to find what exactly the issue was.

Can someone plese give me some ideas.

ray.wurlod · Post by **ray.wurlod** » Thu Oct 31, 2013 1:48 pm

Does the stored procedure work outside of DataStage?

_chamak · Post by **_chamak** » Thu Oct 31, 2013 2:42 pm

Yes Ray, when we run manually from SQL Server studio it works fine with no issues.

kduke · Post by **kduke** » Mon Nov 04, 2013 9:32 am

Probably need to make the job single threaded. The proc probably does not work when more than one is running at the same time.