DSXchange

mallick after trying your method :cry: Still having the same problem droping the null records. These are the messages that I am getting when ever a null is trying to load in Date format field 1)Oracle_Enterprise_17,0: The system(sqlldr test_abb/test_abb@EFDWDVY CONTROL=ora.594072.450364.0.ctl LOG=or...

Yes ray
following is my code in the transformation
If IsNotNull(VALUE_DATE) Then StringToDate(VALUE_DATE,"%yyyy%mm%dd"):'-00.00.00.000000' Else
SetNull()

this is working fine if the target is a dataset
where as my target is relational here it is droping the null records..

Hi ray
I have gone through the null handling in the Parallel Job Developer's Guide and had a look into those functions but still i had the problem of passing the hardcoded null to date field.

If my question is wrong plz rectify me...

I have a scinario where I want to convert string to date. the problem is if I get null value in string it is droping that record. If I take a variable port date datatype, and converting all notnull strings to date and else taking variable port. At that time it is outputting 01/01/2001 in null's posi...