I have a 6 million record flat file where some records have issues. Delimiter is a comma. Text qualifier is quote ". Ex: Bad record -- notice how the extra quotes in the address that is killing the load process. Not all records are like this. "Firstname","Lastname","12"3" Main St" Ex: Good records -- 95% of file. This loads fine. Is there a work around for the above in flat file load without having to find each record manually and then re-saving file. 6 million+ records takes a while. Thx. "Firstname","Lastname","112 Main St"
I would have handle it at Extraction level. Anyhow, If the problem is the load process fails (assuming you are using BULK INSERT TASK), you can handle it by increasing the MAXERRORS (0 indicates that an infinite number of errors are allowed). Hope this helps.