I am trying to improt flat file to sql:
data format : "1/2/2019 12:00:00 AM"
the data type is datatime2 = 2019-01-02 00:00:00.0000000
I tried setting the flat file source to data tie dt_dbtimestamp2 with scale 7
but it is failing with the "conversion failed because the data value overflowed the specific data type"
Any suggestion and help pleasee!!