SSIS Dataflow Task issue, moving data from SQL Server 2008 to MySQL via ADO.Net
That's either a problem with MySql or with the driver you're using. All SSIS knows is that the driver says 'I can't do that'.

The place to start is by manually inserting as record of that kind into the destination db and looking for a more meaningful error.