This may be a misinterpretation, or you may have simplified your situation for the sake of the forum, but could you just have a column in the load table to give a datestamp for the load, and if you need to assign a batch number to that set then have another (parent) table to translate the datestamp into a number?