Thanks Phil, I think that might have to be the solution, I'll have chat with the manager to check on the process that they follow when importing data and see if it can be amended to make it more efficient.

ultimately the import application should truncate the table for each load then run the scripts, so that's another avenue to explore.