invalid Step Script Result value

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  October 20, 2003 at 4:46 am

  #106532

  I'm new to DTS.

  I am tring to execute the following SQL:

  INSERT 
  
  INTO claims_suspense
  
  (claim_number)
  
  VALUES 
  
      (?) 

  but I keep getting the message "Invalid Step Script Return Value".

  I have a parameter set up as a global variable which resolves the value.

  Can anyone tell me what is going wrong? I have tried the SQL statement in QA and it works OK.

  Thanks

  Jeremy

• Jeremy Kemp

  SSCertifiable

  Points: 6754

  More actions

  October 20, 2003 at 6:00 am

  #478759

  I think I have solved the problem.

  I had a workflow script for the task which I have taken out and put into a separate Active X task and it now works.

  Jeremy