Speed up simple SSIS load

• KatieAndEmil

  SSC Eights!

  Points: 843

  More actions

  January 28, 2013 at 6:14 am

  #147816

  Hi

  I just published a new post on SQL Server Central

  SSIS 6 Million rows in 60 seconds using standard laptop[/url] and I was wondering if there are any other ways to speed it up?

  I want to use one physical disk and source as text file (later on I will try additional USB drives and convert source to RAW File)

  Here is my set up:

  Recovery Model: Simple

  Initial DB Size: 1000MB (above what I need)

  Connections: Flat File (fast parse property had little effect) + OLE DB (I tried SQL Server Destination but had minor improvement)

  Buffers: Tried various settings but it seems in this case it doesn't have much affect.

  Is there anything else I can try?

  Man thanks

  Emil

• 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