I need to delete the table (all records) first then need to insert records in the Sql Database.
after ececuting the Interface table is deleted and only first record is inserted in the database. I want to insert all the records which are from the outbound payload.
I am using 2 statements 1 is for DELETE and 2nd is INSERT
____access (didnt mapped in the mapping)
I didnt found and errors in the comm channel, while checking the paylod in the comm channel i see only 1 record is inserted.
key tag mandatory is disabled in the comm channel.
is there any thing wrong in my structure?
Thanks in Advance