Import from File (to MS SQL SqlLocalDB) Inconsistent
Importing essentially the same file multiple times (corrections of errors between passes are the only differences):
3/6/2017
11:13 AM DROP INDEX dbo.dms_folders.dms_folders_folder
11:14 AM TRUNCATE TABLE master.dbo.dms_folders
12:16 PM IMInventory
DMS_PROD_DUMP.csv imported to dms_folders: 8673009 rows (1h 1m 29s 394ms, 446.52K/s)
3832 errors saved to dms_folders_2017_03_06_11_14_26.txt
12:57 PM TRUNCATE TABLE master.dbo.dms_folders
12:58 PM use master
1:00 PM DROP TABLE master.dbo.dms_folders
2:56 PM IMInventory
DMS_PROD_DUMP.csv imported to dms_folders: 15601721 rows (1h 37m 43s 305ms, 280.95K/s)
8 errors saved to dms_folders_2017_03_06_13_18_19.txt
3:31 PM CREATE CLUSTERED INDEX dms_folders_folders ON master.dbo.dms_folders (FOLDER_NUMBER)
3:35 PM TRUNCATE TABLE master.dbo.dms_folders
5:05 PM IMInventory
DMS_PROD_DUMP.csv imported to dms_folders: 13587714 rows (1h 28m 25s 779ms, 310.50K/s)
4 errors saved to dms_folders_2017_03_06_15_35_24.txt
So, between 3 imports of the same CSV, I got imports of 8.6M, 15.6M, and 13.6M rows.
Source file is 1.46GB and 23.3M rows.
Any suggestions?
Running the current EAP 17.1 release.
Please sign in to leave a comment.