More to the point, if the data you are copying is unicode data copying it into a varchar(max) column won't work unless the unicode data can be expressed in the default codepage associated with the collation for that column, which I find is usually not the case. so perhaps you should try NVARCHAR(MAX) instead of VARCHAR(MAX).