In the source I have those funny characters, like the a with the 2 dots over it, etc. In verison 8.7, i have no warnings with the job.
But in the new 9.1 with NLS enables, I am getting the BCI NLS input mapping error. I have tried in the job:
-selected NLS = NONE on both target and source, no luck
-selected ISO8859-1 on both, and either or, still no luck
-set the project to NLS = NONE, no luck
-changed the target fields from CHAR to VCHAR with all above NLS, no luck
-changed the target fields from CHAR to NCHAR and NVCHAR with all above NLS, no luck
I am out of ideas how to get this to not get the warnings.
As my title says, we have 8.7 without NLS installed writing western european oracle database and the job runs fine. Now I have 9.1 with NLS installed with the same western european db and i get these errors.
any other suggestions?
Thanks,
Jennifer
![Crying or Very sad :cry:](./images/smilies/icon_cry.gif)