I am trying to improt flat file to sql:
csv source datatype dt_str data format : "1/2/2019 12:00:00 AM"
the data type in database is datatime2(7) = 2019-01-02 00:00:00.0000000
I tried setting the flat file source to data tie dt_dbtimestamp2 with scale 7
casting to varchar50 in lookup is hanging the package. inert goes fine.
Any suggestion and help pleasee!!