how to avoid null values from flat files
in my source i am getting null values how to avoid it in source
ID,NAME,JOB,SAL,DEPTNO
1,CHARAN,sse,15000,10
2,RAMU,tl,null,20
3,null,DE,13000,30
4,ANAND,se,null,40
5,TEJA,PM,11000,20
6,srinu,PM,11000,20
7,sam,se,90000,30
8,david,tl,45000,30
May 9th, 2012 12:13pm
Hi, it's null value or "null" string?
In any case, you can use Derived Column transformation to replace existing column with expression similar to this:
ISNULL([NAME]) ? "" : [NAME]
David.
Free Windows Admin Tool Kit Click here and download it now
May 9th, 2012 12:28pm
If it is a textual NULL (as should be in a flat file) then the expression should be
[NAME] == "null" ? "" : [NAME]
Arthur My Blog
May 9th, 2012 12:35pm