Home Forums SQL Server 2005 Administering Bulk Insert batch error RE: Bulk Insert batch error
Willem G
SSC Eights!
Points: 809
More actions
July 6, 2009 at 7:25 am
#1020352
Michael,
ROWS_PER_BATCH is not the same as BATCHSIZE (check out BOL), and is only used for optimizing, not for transactional purposes. That may explain the behaviour you experience.