I ran into what appears to be the same issue.  it turns out that the SQL Server varchar field has a max. size of 8000.  So, if you try to 'update' a row with more than that, you'll get the error message indicating your data has been truncated, or something to that effect.

 

Darold