I have a SSIS package that reads a csv file, one of the columns contains a date-time string such:
DatePaid
2020-12-03 15:22:45
I am using the derived columns transformation editor, and would like to find out how can the date-time string can be converted to only date.
Will it be like this:
(DT_DBDATE)[DatePaid]
Is it possible to get some help with an example?
You can use a new column
DatePaidConverted
and add(DT_DBDATE)[DatePaid]
in theExpression
. In your destination, mapDatePaidConverted
to[DatePaid]