Hi,
I use a SQL adpater and my database is in SQL 2000.
I have a stored proc that inserts records in the database. There is a file with multiple records. In the orchestration I pick up each record and then insert it in the database. Thus as many number of records those many times my stored proc is called to insert the record. All this is done through SQL Adapter. Now if an error occurs in a record the message is suspended in the message queue and then the next record is picked up. Thus if out of 10 my 2 records have any problem they will be suspended and the next 8 are inserted in the data base. I want to roll back the other 8 incase an error occurs . Can anyone help me with this? I did try using compensation handler but that did not help
Thanks.