SSIS convert datetime string to date yyyy-mm-dd

Question

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?

Does this answer your question? [How do I extract just the date from a SQL datetime value in SSIS?](https://stackoverflow.com/questions/1924717/how-do-i-extract-just-the-date-from-a-sql-datetime-value-in-ssis) — Amira Bedhiafi, Dec 07 '20 at 22:32

score 1 · Accepted Answer · answered Dec 07 '20 at 22:45

1

You can use a new column DatePaidConverted and add (DT_DBDATE)[DatePaid] in the Expression. In your destination, map DatePaidConverted to [DatePaid]

answered Dec 07 '20 at 22:45

Amira Bedhiafi

8,088
6
24
60

SSIS convert datetime string to date yyyy-mm-dd

1 Answers1