ETL Enterprise 5.7.6.18 Error when import date value is empty or null

Hello:

we are having an issue with date values when reading from a txt file. it seems that when we read a date field that has several empty valued records when it does encounter a populated value, ETL then seems to retain that value for all subsequent records rather then reading further empty or Null values. the destination SQL table does accept NULL for this field and I am filtering any empty strings and converting to Null.

• As you can see form the Transform input, we can read the txt file no problem and the ActualCo fields #4 shows both empty date values and populated ones
• In the validator, we check for empty string values for the date fields and replace with NULL
• in the transformaer we check the date formate
• in the transformation out, you can see it seems to populate all the Actual Departure fields with a value.

Any Help would be appreciated, this is a critical issue for us, as this task is causing lots of downstream issues.

thanks

mike

We have reproduced the problem

Peter

Can you try latest version please

Mike