Hi @pat dev ,
We can use Derived Column Transformation to convert the datatype from dt_str to dt_dbtimestamp2.
Expression: (DT_DBTIMESTAMP2,7)((DT_DBDATE)(TOKEN(Date," ",1)))
Please refer to the following pictures:
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.