I have a flat file where I am importing 18.9 million records. I am using the following transformations inside the package: ScriptTask, Unpivot, Union All Lookups, dataConversion. I am using the "Out of the box" settings on the dataflow properties. I tried adjusting them by setting the maxRows to 500,000 and updateing the DefaultBufferSize to 100485760 and set the engine threads to 16 since I have 4 quad core processors but all of this made it slower than the default settings. My process is taking 14 hours. Is this good? I sure hope not. What can I do to boost the performance?