Procedure calls using ODBC stage
Posted: Fri May 08, 2015 6:41 am
We have one procedure calling a few procs within it and we are executing this procedure using an ODBC stage and the goal of this job is that even if some procs within it execute with warnings (raised exceptions) we should have the job finish with warnings but not abort..
currently what is happening is we are getting this erro..
DSD.BCIOpenR call to function SQLNumResultCols failed.
Is there a way for an ODBC stage to allow multiple output codes. If we use STP stage, we are not able to see any warnings when procs have exceptions, it just lets the job finish successfully..
currently what is happening is we are getting this erro..
DSD.BCIOpenR call to function SQLNumResultCols failed.
Is there a way for an ODBC stage to allow multiple output codes. If we use STP stage, we are not able to see any warnings when procs have exceptions, it just lets the job finish successfully..