I have a large csv file with over 2 millions rows of data.
I am using the Export to DB (MySQL) command to load the CSV file into table.
My problem is that when the load runs into an error, I get a generic error message saying the SQL is invalid near ’ '
Sometimes I can infer which row is the offending one and filter it out.
But at other times, the row fragment is so simple, I can’t determine which column the value came from.
Each row in my csv file contains a unique “transaction id.” If this were included in the error message, it would be so incredibly easy for me to trouble shoot and fix individual rows. Is there a way to more easily determine which row is failing to load?
p.s. I tried using the bulk insert but this was worse in that it merely errors out with “A fatal error has occurred.” It gives me nothing to work wiSo I won’t be using bulk insert at present.