Fuzzy lookup gives error with nvarchar(max)

  • Hi guys

    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.

    Kind regards

    Fred

     

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply