Avoiding CSV Errors

Following the Staged Planning Load File Guidelines will ensure that CSV errors do not occur. Aside from basic data structure, the following "quick guidelines" will ensure an error-free load:

  1. Follow the structure of the destination table accurately.

  2. Note: If a destination table has 5 columns but the last 2 columns have no data (and are nullable), define them appropriately:

  3. As a rule of thumb, always qualify each column using double quotes ("). If a double quote character exists as valid data in a column, replace it with a single quote ('Johnny').