issue while executing stored procedure

[rkdatastage]

Hi All
I am trying to call a stored procedure from a datastage job through ODBC Enterprise Stage.

The error is like this :
ODB_ROLLBACK_STOREDPROCE: Write mode failure: exec CTRL.DBo.sp_rollback_cp, '821001',
'CTRL.DBo.LoadStatus','CPY.testcopy.WH_EMP' doesn't exist.

The 4 parameters i am passing are stored procedure name, Loadstatusid,control table and target table .

i am using SQLSERVER 2008 database.

Any thoughts , please share

Regards
RK

[nikhilanshuman]

do you have write privileges on the database?