When synchronizing or executing a NAV data source, the following error message may appear.
The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.
When using the NAV Adapter data source type, this error message has been tied to the value set for the 'Option Field Text Length' in the Navision Enhancements Settings .
To change this value, right-click on your NAV data source and select Enhancements > Navision Enhancements Settings as shown below:
In the window that opens, adjust the 'Option Field Text Length' to a value large enough for your existing Option Field values. Click OK to continue.
After adjusting the 'Option Field Text Length', you will need to synchronize the data source objects for the updated length value to be applied to the corresponding tables within your staging database. To do so, right-click on your NAV data source and select 'Synchronize Objects'.
In the ensuing window, simply click Start to begin the process.