How to import table's data in MySql from Sql Server?
You could try changing the datatype in SQL Server to VARBINARY(MAX) :

http://wiki.ispirer.org/sqlways/mysql/data-types/longblob 

Even if this is just to get your data into SQL Server. It may also be worth noting that IMAGE is being removed in future editions of SQL Server.