Thank you Koen and Jeff for the great advise. I'll look into the partition approach. I think that is the best option for me.

Thanks Jeff.

Do you have the answer for my question? 2 million or 0 row?

My gut tells me that I have to set the Maximum Insert Commit Size =...

I need to load a flat file of 12 million records to a table. I want it to be All or None as an success or failure.

So if I...