Red Gate forums :: View topic - CSV import and null values
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

CSV import and null values

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
i8beef



Joined: 13 Dec 2013
Posts: 1

PostPosted: Fri Dec 13, 2013 6:35 pm    Post subject: CSV import and null values Reply with quote

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.
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 205

PostPosted: Mon Dec 16, 2013 8:04 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group