Executing SQL Server Stored procedure
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 90
- Joined: Mon Dec 08, 2003 4:48 am
- Location: Chennai
Executing SQL Server Stored procedure
Hi,
I am calling a SQL Server stored procedure using an ODBC stage. The stored proc is inserting rows in few tables. The job runs to successful completion but there were no rows inserted. When the stored procedure is executed via query analyser it is inserting rows. I am not able to find out what is the issue. Is there any way that i could get more info from the log or to nail down the issue?
I am calling a SQL Server stored procedure using an ODBC stage. The stored proc is inserting rows in few tables. The job runs to successful completion but there were no rows inserted. When the stored procedure is executed via query analyser it is inserting rows. I am not able to find out what is the issue. Is there any way that i could get more info from the log or to nail down the issue?
Think Ahead,
Raj.D
Raj.D
-
- Participant
- Posts: 90
- Joined: Mon Dec 08, 2003 4:48 am
- Location: Chennai
-
- Participant
- Posts: 90
- Joined: Mon Dec 08, 2003 4:48 am
- Location: Chennai
-
- Participant
- Posts: 90
- Joined: Mon Dec 08, 2003 4:48 am
- Location: Chennai
-
- Participant
- Posts: 90
- Joined: Mon Dec 08, 2003 4:48 am
- Location: Chennai
-
- Participant
- Posts: 90
- Joined: Mon Dec 08, 2003 4:48 am
- Location: Chennai
Hi,
We're also trying to call a SQL Server stored procedure from DS. It seems that only the "ODBC" Server stage has the stored procedure option. I do not see the stored procedure option in the "ODBC Enterprise" or "Stored Procedure" PX/EE stages.
Am I missing something? Did you register the Server version of the ODBC stage in your parallel job?
thanks,
Rob
We're also trying to call a SQL Server stored procedure from DS. It seems that only the "ODBC" Server stage has the stored procedure option. I do not see the stored procedure option in the "ODBC Enterprise" or "Stored Procedure" PX/EE stages.
Am I missing something? Did you register the Server version of the ODBC stage in your parallel job?
thanks,
Rob
sorry, I meant to say that there's no SQL server option in the stored procedure stage, which has already been mentioned.chulett wrote:What "stored procedure option" would you be looking for in the Stored Procedure stage?roblew wrote:I do not see the stored procedure option in the "ODBC Enterprise" or "Stored Procedure" PX/EE stages.
Thanks