on 05-22-2015 4:24 PM
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?
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.