Issue in Handling Special Character Data in Enterprise Stage

[DSDexter]

Aqulis,

So your job is loading Data fine with DRS stage and not with Oracle stage, Is that correct?

Try keeping the target datatype as unbounded varchar and try with Unicode set and unset as well.

Also is the target written in LOAD mode or Upsert?

[kandyshandy]

Did you set "Table has NVarchar columns" in Oracle EE stage?