Additional tip for you.

I suggest that you need to create a log on every transaction event in your program. You can write your log to text file or whatever approach.

Example:
After copying data from Table1 which is the data source to destination table you create a log. This is very useful for you to check the status of data transfer. You can keep track which part of the transfer have an error. Your log must have a date and time of transfer, what table transfer and how many records transfer.

To illustrate it:

Begin Trans
insert into destinationtable .... from table1

...write your log here to a text (e.g. event.log)
end trans


Begin Trans
insert into destinationtable .... from table2

...write your log here to a text (e.g. event.log)
end trans

.... and so on.


Mabuhay.....


Rene