BPM question - Delete all entries in a table and Insert data

Hello,

I'm new to PI BPM and have this scenario to implement.

I'm supposed to delete all entries in a table and then insert data to the same table.

Is BPM necessary? If it is, what is the best practice to implement my scenario?

I want to make sure that all entries were successfully deleted before insert data.

How do I check if all entries in the table were deleted successfully before

initiating insert.

Thank you.

-Won