Home Forums SQL Server 2005 Administering Bulk Insert batch error RE: Bulk Insert batch error
Willem G
SSC Eights!
Points: 809
More actions
July 7, 2009 at 1:41 am
#1020907
It may look somewhat confusing. Check out the explanation in BOL 2005 on 'Managing Batches for Bulk Import'. ROWS_PER_BATCH is a performance parameter, not a parameter that manages the batch size. BATCHSIZE takes precedence when both are specified.