I have encountered small issue in sql server. any sql server expert out there, please  help.

i have a sql server job from where i have to passparameter into oracle proc. what i did is
i created dts pkg called "my_dts_pkg and used that oracle proc in there.
now, how do i pass parameter value from my sql server job to oracle proc in my dts pkg..

here is my script used in dts pkg

DECLARE
  V_JOBNAME VARCHAR2(20)   ;
  V_FLAG    VARCHAR2(10) ;

BEGIN

 
  if
  V_FLAG = 'COMPLETE'
 
  then 
 

  ORACLE_COMPLETE_JOB ( V_JOBNAME );
 
  end if;
 
 
  if
  V_FLAG = 'FAILED'
  then
 
 
 
ORACLE_FAILED_JOB ( V_JOBNAME );
 
 
 
 
  end if;
  COMMIT;
END;




My sql serer job setp from where i am calling above dts pkg


 DTSRun /S "(local)" /N "my_dts_pkg" /A "V_JOBNAME":"8"="ok" /A "V_FLAG":"8"="COMPLETE" /W "0" /E



here is my problem. I am not able to pass this parameter from my sql server job to my_dts_pkg.

is there anybody out there who has done this.

any help is appreciated.