• 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.