Although it took me some more time than I had anticipated, I finally was able to run an SSIS upload package with real data on the development machine. When I first tried it, the upload was still running after more than an hour (at which time I aborted it). Now, with all the caching fully enabled (and working :-)), the total upload takes just under 8 minutes for +8M records, which comes down to more or less 17K records/s. Not bad, not bad at all…

Advertisements