In a SSIS package, how do I convert an import a text field(dt_str) to a time7 datatype in sql 2014. In other data flows, a script component was added and then in the script editor we would write code like this example
row.dfas = convertdatestring(row.column9)
this data flow was created years ago. Editing it is okay, but now I am creating another data flow from scratch in VS 2017 with SSDT and that code does not work. the only command close is convert, and it does not tell me how to write the rest.
the dt_str coming is in in a number format of 6 characters. It needs to go into SQL 2014 as time. It is supposedly in 24 hr time format
Any help is appreciated

