I need to push data in ms sql 2008 by taking it from excel file, where target columns have datatype is nvarchar(max), However such data type does not exists in bods 4.2. There is option while importing file, where i can declare utf-18 as code page but not sure if that will resolve the situation.
The tables are already there in ms sql 2008 with nvarchar(max) data type. But when i import those existing table in data store from ms sql 2008 and make them as target in job. The mapping of columns to target table is not getting accepted as the target table column data type is not being mapped to valid data type.
How do i solve this, Could you please help?