• You can try BCP. It has options to inset rows in batches.

    BCP is known to be faster than other methods.