ImportType 0 - cannot insert NULL into attribute with length less than 6 RRS feed

  • General discussion

  • We are trying to set a Text attribute of length 2 to NULL.  We cannot use Import Type 2 because we have two different sources for the entity.  Each source populates different attributes.

    When using ImportType 0, you need to write the string ~NULL~ to set the value to NULL.  This is not possible because the column in the staging table is nvarchar(2).

    Is this going to be fixed?

    Perhaps including a bit field to set values to NULL could work, as per Olof Szymczak's suggestion on the TechNet article?

    Michael Fenton, Principal Consultant, MIPman IT

    Friday, May 9, 2014 1:22 AM