Hi,

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
source table.

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.

Regards,

Tom