I have an Excel source file and I want to do a fuzzy lookup, matching it to a column surname(nvarchar(max), null) in a table in the database. This database column in fuzzy lookup is a unicode text stream (DT_NTEXT). I place a data conversion between the Excel file and the fuzzy lookup and change the DT_WSTR to DT_NTEXT and when I try to map the two columns I get the error: The following columns cannot be mapped: [Copy of Surname, surname] One or more columns do not have supported data types, or their data types do not match.
Does anyone know what I'm doing wrong? Your help would be greatly appreciated.