CSV import and null values

The simplest way to populate your database with test data.

Moderators: JonathanWatts, David Atkinson, Anu Deshpande, Michelle Taylor, Lionel, Emma A, sherr

CSV import and null values

Postby i8beef » Fri Dec 13, 2013 6: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 6:32 pm

Postby Manfred.Castro » Mon Dec 16, 2013 8: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 2:49 pm

Return to SQL Data Generator 2

Who is online

Users browsing this forum: No registered users and 0 guests