Hi,
I have an issue with the loading of our data warehouse to do with special characters.
The source seems to replacing the characters with a % symbol, and I'm struggling to resolve it without changing the underlying table type from VarChar to NVarchar (which I really don't want to do).
The source database is on the same server as the warehouse but the collations are different.
The source database has a sort order of 850
The destination database is a sort order of 1252
Source and destination columns are both Varchar(50).
I can perform a simple SQL Update on each database and the characters are accepted.
If I perform a Preview on the OLE DB Source it shows the fields correctly, but when I run it (and put a data viewer on it) I can see the special characters are lost.
I've been playing with the DefaultCodePage and AlwaysUseDefaultCodePage on the Source connection with no joy.
Am I looking in the correct place?
Thanks,
Graham