Fuzzy lookup gives error with nvarchar(max)

• frdrckmitchell7

  Ten Centuries

  Points: 1351

  More actions

  May 6, 2021 at 1:28 pm

  #3880110

  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

   

  • This topic was modified 3 years, 6 months ago by  frdrckmitchell7.

• Site Owners

  SSC Guru

  Points: 80330

  More actions

  May 7, 2021 at 2:10 pm

  #3880553

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

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