Page 1 of 1
Posted: Thu Jul 02, 2015 8:11 am
by ShaneMuir
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?
Posted: Fri Jul 03, 2015 1:07 am
by dveltman1
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.
Posted: Fri Jul 03, 2015 3:19 am
by ShaneMuir
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.
Posted: Fri Jul 03, 2015 7:24 am
by dveltman1
It is in varchar unicode, both input and output.