While running the jobn i foun the following error
Data flow DF_ xx embedded Dataflow ConvertDateToChar Cannot convert string <1900.01.01 00:00:00> to date using format string <YYYY-MM-DD>.
i think the date has not properly inserted by the enduser ?
i just want to know at which level it has to be rectified ? do the enduser has to rectified ? or do we need to do the changes.
please assit ( new to this)
Edited by: MDFASI on Feb 22, 2012 6:27 AM
I did not understand your problem quite clearly.
Do you have problem at source or target? Are you trying to convert date to char or string to date?
If it is the former then use to_date function or if the issue is latter then you have to use a combination of to_char>to_date function.
You can do the changes inside DS.
First, identify the field in which the value 1900.01.01 00:00:00 comes from the source, inside DF_ xx embedded Dataflow. Check what is the mapping for the same to output.
Mostly, there has to be a to_date function like
Change the same to
Though there will be a warning, this has to give you proper value in the output. Replace DATE_Column with your actual column in the code mentioned above.