Home Forums Data Warehousing Data Transformation Services (DTS) How much faster is bulk insert? RE: How much faster is bulk insert?
Todd Painter-134230
SSC Veteran
Points: 207
More actions
December 7, 2005 at 2:57 pm
#608275
I personally always use the transformation task since it's the only one that can go both ways. As long as you specify a decent batch size the speed difference between the transformation task and the bulk insert task is minimal from my experience.