Import error

ketanshah123 · Post by **ketanshah123** » Mon Jun 09, 2008 6:01 am

Hi

In my source .csv file a field if null is indicated as null (small caps without quots) and in my target file same filed is nullable = true

I am applying the If field=''null'' then set null else field value
(I have to apply above if then else )

But I am getting

Xfr_Map,1: Field 'field_name' from input dataset '0' is NULL. Record dropped.

adn records getting dropped ...
please suggest some solution for same ...

thnx in advance

ArndW · Post by **ArndW** » Mon Jun 09, 2008 6:39 am

I hope you are using SetNull() instead of what you posted.

This error means that your input value hasn't been read the way you expect. What is the datatype of this field where you are assigning "null"?

ketanshah123 · Post by **ketanshah123** » Mon Jun 09, 2008 6:45 am

hi
I am using setnull() and both source and destinition fields are of integer type

ArndW · Post by **ArndW** » Mon Jun 09, 2008 6:52 am

Well, how can you put the value of "null" (as a string) into an integer field? What happens is that the value of "null" is not valid, you have not set a default value and the field is nullable - so it uses a null value which I gather is what you want. So you don't need the transformer logic.