I think the retain NULLs option is to prevent column defaults being applied on the destination table during import, not for converting empty strings to dates within the pipeline.