Please don't double post. The original post is Getting error when loading null values in ssis. As we said in the other post, it is not null in the csv, it has the words NULL in it so it is reading as a string. If it were csv, the file should look more like this:
1 |a ||
2 |b ||
3 |c ||
|d |10 |
You'll probably have to read it like a string, then convert 'NULL' to null