Home Forums Data Warehousing Integration Services Speed up simple SSIS load RE: Speed up simple SSIS load
KatieAndEmil
SSC Eights!
Points: 843
More actions
January 28, 2013 at 8:26 am
#1581652
Just an update... I changed Package Size to 32k and Commit size 0 and load completes within 43s. (from 100k rows per sec to 139k per sec)
Regards
Emil