Ok now i have it running through the scd and i am getting no updates. i get a parameter #26 has not been set read out.
Why can i not update the creation input field value for scd_start?
Hi, The error indicates the data type is not matched, it is trying to insert a datetime value into a numeric column, please check that: 1. The data type of this column is datetime in table. 2. The order of columns on the schema is the same as it is in table.
does anyone know about the "Implicit conversion from data type datetime to numeric is not allowed. Use the CONVERT function to run" error code
It sounds like this error message comes from your database (?) and suggest to use the CONVERT sql function to change the type of a field. Please find more information about CONVERT sql function on :
http://www.w3schools.com/sql/func_convert.asp Another way is to manage the data type thanks java, directly in the job design. Set the schema column with the expected type is not enough, you should ensure that the values of the data are in the same format. To more information about how to parse a date, please read:
https://help.talend.com/search/all?query=TalendDate+Routines&content-lang=en HTH
ok i have it running now thanks Now my new out put is not what i wanted it to be. If a row changed between the two files i need to make a end date on the old data and a new start date on the current data with an open ended end date. when i run it now it gives me the job start date and a null end date.
