CSV import and null values
i8beef
Posts: 2
We have a CSV file that get's imported where the last column in the bunch of NULL for all entries.
When we import this, all other entries get mapped to a real NULL except that last column, which is always set to the string "NULL". Is there a way around this?
Edit: Actually, it appears that this is the issue when the type of the column is nvarchar. It will always put in the string value "NULL" instead of NULL.
When we import this, all other entries get mapped to a real NULL except that last column, which is always set to the string "NULL". Is there a way around this?
Edit: Actually, it appears that this is the issue when the type of the column is nvarchar. It will always put in the string value "NULL" instead of NULL.
Comments
I was able to reproduce the reported behavior and have logged it under the internal reference number of SDG-1047
As a workaround if all values in the column are null you can use a regexp generator for the column and just set the allow null values percentage to %100
Product Support
Red Gate Software