I have a datefield in ssis in this format - '2012-03-20 08:30:00'.
I would like to remove the time field from datetime column and hardcode a timefield 02:00:00.
(DT_DBDate) '2012-03-20 08:30:00' ----> '2012-03-20 00:00:00'
I would like to hardcode and concatenate a time field "03:00:00" to the date field. The time field is static and will be d same for all date records.
Could any 1 let me know the ssis expression in dervived column for the same.
Any help on this?