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.