Competition: What’s your favorite Redgate tool? Enter now.

CSV import and null values

i8beefi8beef 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.

Comments

  • Thank you for reporting this issue to us.
    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
    Manfred Castro
    Product Support
    Red Gate Software
Sign In or Register to comment.