I am executing a procedure inside a DTS package, where in the SP i call another SP which insert rows one by one passed as a parameter. The inner SP is in a while loop. THe whole setup looks like... -- Outer SP WHILE @Current_Row < = @Row_Count BEGIN /* Get the required values to be passed as parameters*/ SELECT @Store_Ref_No = Store_Ref_No , @Cash_Total = Cash_Total, @Voucher_Total = Voucher_Total from @tbl_Bureaux_Trans_Load where Row_Index = @Current_Row /* Call the stored procedure to create RE transactions for the store and update relevant tables*/ EXEC @Return_Status = Usp_Scms_Update_Bureau_Trans @Store_Ref_No, @Cash_Total, @Voucher_Total -- Inner SP Now when this inner SP fails, i am handling it by getting the output result and storing the error value in a separate table just becoz i dont what the outer SP to fail but to run for all the values in the while loop without failure. The DTS Package successfully executes all the values in the while loop successfully regardless of the failure of the inner SP. But after finishing the loop the DTS package fails saying that insert failed. how can i avoid this error message and make the DTS package refrain from throwing that error message. Thanks, Ram "It is easy to write code for a spec and walk in water, provided, both are freezed..."