DSXchange

Posted: **Wed Sep 19, 2007 1:02 am**

Hi All

My requirement is that i have to see warnings for the null values also.
My source is a csv file with 5 columns only and target is relational table.
Taret is something like EMPID,ENAME,LEVEL1,LEVEL2,LEVEL3.
EMPID is a primary key.
My scenario is if the level1,level2,level3 are null there must be a warning message in the director as these columns are null inspite of job being succesful and all othe columns are loaded,which i am not able to see now.
Could any one please help me out in this....

Thanks

Posted: **Wed Sep 19, 2007 1:12 am**

Derive a stage variable as

Code: Select all

If IsNull(InLink.Level1) Or IsNull(InLink.Level2) Or IsNull(InLink.Level3) Then UtilityWarningToLog("Level field is null") Else 0

. You don't have to use the stage variable.

Posted: **Wed Sep 19, 2007 1:19 am**

my doubt is in database are these columns ,LEVEL1,LEVEL2,LEVEL3. null or not null, if it is not null then you can use "Treat Warning as error message checkbox", but then your job will not run.

if they are null we can find some solution for your implementation.

Posted: **Wed Sep 19, 2007 2:29 am**

sorry regarding improper relply, yes the sdk routine UtilityWarningToLog is what you wanted

DSXchange

Warnings for Null Values

Warnings for Null Values

Re: Warnings for Null Values

Re: Warnings for Null Values