Skip to Content
avatar image
Former Member

Nvarchar support using Bods 4.2

Hello Friends,

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?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    May 22, 2015 at 04:02 PM

    When using nvarchar(max), this should be converted by DS to long data type . Can you change the datatype in you schema in or schema out?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      Hi,

      You can declare the fileformat code page to utf-8, the DS job server must also be able to handle utf-8 as well as the target database.

      Do you actually have any problems with the characters being loaded?