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