MySQL to MSSQL via linked server: blob to varbinary -
i have mysql database need imported sql server via linked server. 2 of mysql columns blob , mediumblob. columns in mssql varbinary(max). when execute query @ linked server, error: ole db provider "stream" linked server "(null)" returned message "multiple-step ole db operation generated errors. check each ole db status value, if available. no work done.". msg 0, level 11, state 0, line 19 severe error occurred on current command. results, if any, should discarded. the error goes away when exclude blob , medium blob columns select statement. there conversion or workaround this?