Large CSV file import to SQL Server is taking a very long time. Toad does 1 row at a time and it's very slow. The "Optimize block size" option does not make it faster. If it's un-checked, the "Processing row count:" set to 2000 does not work either.
Cause 1:
The ‘Optimize Block Size’ option doesn't work for a CSV file that is in a network path.
Cause 2:
User checked the option, "If error occurs, save unimported rows to a discard file (csv)".
WORKAROUND 1:
Locate your CSV file in a local drive instead of a network drive / path.
WORKAROUND 2:
Un-Check the option, "If error occurs, save unimported rows to a discard file (csv)". In order to write a single error row at a time, Toad has to insert one row at a time. So if user selects to write errors to csv, it disables the ‘Optimize Block Size’ option.
STATUS:
Waiting for fix in a future release of Toad Data Point.
