Hi I tried my best to convert the string to date format by pulling the flat file into the oracle tables.
data in csv file is in follwoing format:
Fri Oct 10 10:53:13 2008
Need to convert to Date format oct-10-08
I tried to put the derived column and wrote an expression for the following:
Substring([CREATIONTIME],5,3) + "-" + Substring([CREATIONTIME],9,2) + "-" + Right([CREATIONTIME],2).
i then converted to DT_DBTimeshamp using data conversion (which is shown in the oledb destination column. it s failing because of type cast error...
Could you please guide me .. t