EXECUTING Stored procedure in BODS not running completely in SQL Server

Hi ,

I tried to execute Stored procedure using SQL() and also tried by importing SP as function in my Data store. It shows Job executed successfully but only 2 tables data got inserted which is not the expected result.

sql('XXX','EXEC dbo.CC_Conversion_Master \'CC:25\',\'Migration_ST\',\'dbo\',\'Mig_Stage2_ER031KU\',\'dbo\',1,0,0,0');

The same SP when i executed directly in SQL server, It is giving me expected result by inserting data into 39 tables.

Can you please tell me whats causing this issue via BODS