SSIS data Import from MySql

Question

I am working with SSIS and trying to import data from MySql to SQL Server. I am having issues trying to convert mySql datetimes to SQL Server Datetimes. Any suggestions?

Answer 1

Try convert date to string and then to datetime again.

Answer 2

What is the issue? Which SSIS data type are you using? DT-DBTIMESTAMP should work for both.

Answer 3

Can you provide an example of the error or problem? I found some values in MySQL were out of range to SQL Server. In these instances, I used a NULLIF on the MySQL side to remove the bad values first. Rafal Ziolkowski's solution of converting to strings could work as well, but I personally would prefer to push the conversion off to the MySQL query if it is only impacting data columns.