>Did you try to load directly ? If so, error or exponential slowdown ?
>
I did try originally using Tasks/Import. It produced an error on ~7mln. row and so thus I decided to split and load by 1mln rows. Unfortunately, I could not figure out a way to run the package not from VS in debug mode which is quite slow. So far the process is still going and I loaded up to the beginning of 4. Still have 38 more files to load, I suspect it'll finish tomorrow with this speed.
If it's not broken, fix it until it is.
My Blog