Parallel job problem with NLS/BOM

ShaneMuir · Post by **ShaneMuir** » Thu Jul 02, 2015 8:11 am

So can you manually insert those characters into the DWH? (Just trying to ascertain if the DWH can actually accept those char)

Do you have the column data types set appropriately in your DS job?

dveltman1 · Post by **dveltman1** » Fri Jul 03, 2015 1:07 am

Hi Shane, thanks for the fast reply.

I manually inserted the records from the SQL overwrite into the DWH and that works fine, no adjustment of characters.

The column data types are OK in DS.

It looks like the DS proces is transforming the characters.

ShaneMuir · Post by **ShaneMuir** » Fri Jul 03, 2015 3:19 am

What is the column data type you are using for the column carrying this data?

If you are not already - try setting it to either NVarChar or Varchar Unicode.

dveltman1 · Post by **dveltman1** » Fri Jul 03, 2015 7:24 am

It is in varchar unicode, both input and output.