CSV import and null values

The simplest way to populate your database with test data.

CSV import and null values

Postby i8beef » Fri Dec 13, 2013 5:35 pm

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.
Posts: 1
Joined: Fri Dec 13, 2013 5:32 pm

Postby Manfred.Castro » Mon Dec 16, 2013 7:04 pm

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
Posts: 209
Joined: Mon Apr 23, 2012 1:49 pm

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests