Error: Error importing the finder file: Unable to import file from the server. The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.

When importing a Finder File, a user may receive Error:  'Error importing the finder file: Unable to import file from the server. The given value of type String from the data source cannot be converted to type nvarchar of the specified target column'. 
This is generally caused by either bad data, invalid characters, or formatting of the file.

When presented with this error, review the Finder File for the following : 
  • Unclosed quotes. Quotes are used to allow commas inside of a string in a .csv file. Unclosed quotes will cause the import process to look for the next matching quote ( " or ' ) and insert everything between them into a field, resulting in the error.
  • Extra spaces in the file. Too many trailing or leading spaces can overflow the maximum character column values in the temp table that is used by the finder file import process (4000 characters per field).
  • Invalid characters in the Finder File.

Environment

 3.0.516.42
 4.0.131

Was this article helpful?