title: Wide varchar field causes "Requested conversion is not supported" error using openquery with MySQL linked server
body: <p>I'm trying to migrate a table from MySql to MSSQL using <code>openquery</code> but I keep getting the following error message:</p>
  
  <pre><code>OLE DB provider "MSDASQL" for linked server "MYSQL" returned message "Requested conversion is not supported.".
  Msg 7341, Level 16, State 2, Line 1
  Cannot get the current row value of column "[MSDASQL].description" from OLE DB provider "MSDASQL" for linked server "MYSQL". 
  </code></pre>
  
  <p>The SQL query I'm trying to run:</p>
  
  <pre><code>insert into dbo.tickets (id, description, createdAt)
  select * from openquery(MYSQL, 'select * from mydb.tickets')
  </code></pre>
  
  <p>With <code>openquery</code> I have already copied a couple tables but this one tricks me.</p>
  
  <p>On both side of databases the <code>description</code> field is <code>varchar(8000)</code>. In MySql there is no row where description is null and the longest description is only 5031 characters.</p>
  
  <p>I tried creating a new view in MySql with the same data structure but got the same error.
  I can't determine which row has an invalid description field because the table contains more than 65000 rows.</p>
  
  <p>I also tried dumping the data into an SQL file but I got <code>OutOfMemoryException</code> in Management Studio. The dumped sql file itself is about 60 MB.</p>
  
  <p>Any suggestions or other ways of migrating this data?</p>
  
  <p>Thanks in advance!</p>