• It's a csv file.

    "123456432",0,0,0,0,"3214","21/04/2009"

    The second value in the file is a date field. This file is automatically generated from prog with lots of other information including dates. Some fields have dates and some don't. Null string date type field is giving problem while loading data to datetime column