The column '%1!s!' does not have a valid data type for the ORDER hint specified for data source '%2!s!'. The text, ntext, ...

The column '%1!s!' does not have a valid data type for the ORDER hint specified for data source '%2!s!'.  The text, ntext, image, xml, varchar(max), nvarchar(max) and varbinary(max) data types cannot be used in the ORDER hint for a BULK rowset or CLR TVF.