ETL and Data Integration tools - Modern ETL software for everyone

Hello

I am trying to load data into PostreSQL from fixed width file

Some date fields come empty (for example: order date end and payment date) in some rows.
So, this field must remain empty in the table.

How ever all those records with empty dates are failing to load

What do I have to do?
Thanks,
Boris

Hello

You are not loading empty string you are loading string full of spaces

Try setting "On Error" to null

Please let us know the outcome

John,
www.etl-tools.com

Thanks for help

It is all working as expected

Boris