You are not logged in.
I have a job that reads from a table on one server and uses the tMysqlOutputBulkExec component to load
the data to the 'same' table on another server and am encountering an issue with the date fields on the
target table. The date fields are getting loaded with a value of 0001-01-01 and not the date value from the
When I run the same job using the tMysqlOutput component, the date fields are loaded properly. With
this in mind, do I need to add anything to the Advanced settings tab to allow for the date value to get loaded
correctly from the source table to the target table? Or is there a setting elsewhere what needs to be updated?
I would prefer to use the bulk loaded component due to there being quite a bit of data being moved around.
Thank you in advance. If additional information is needed, please let me know and I will provide it.
That's because you didn't set data pattern of this date column correctly.
Maybe the data patter of this column in DB table is "yyyy-MM-dd".
But in Talend job, you set it "dd-MM-yyyy".
Then you will get value like "0001-01-01".