I just published a new post on SQL Server Central SSIS 6 Million rows in 60 seconds using standard laptop
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?