MySQLbulkexec incorrectly loading bit and date datatype columns

[Anonymous]

HI,
I am using TOS. I am outputting the data from a table in sql server to a file. It has boolean and dates columns. 
Later I am using mysqlbulkexec to load to a table in mysql.
However, even though the load is successful and all rows are loaded. The bit columns are all loaded with 0 values while in the original sql server table there were values of 1 as well. 
The dates are loaded as 

0000-00-00 00:00:00

Any ideas on this would be helpful

Thanks in advance
Rathi

[Anonymous]

Hi,
What does your loading data look like? How did you set your data type in schema setting? More information will be preferred.
Best regards
Sabrina

[Anonymous]

Hi,

Try to change the page code type to "ACP" or "OEM" and the type data file to "CAR" under Advanced settings of your component