How about preprocessing the data? Process the data into everything you need for one transaction and then load one transaction at a time. Then, if necessary, you can close the connection between each transaction.