DSXchange

Hi Im using ODBC stage to extract sata from oracle table, all the fields are varchar, still im getting this warning mesage:

ODBC_Enterprise_144,0: Invalid character conversion found converting to ASCL_ASCII, substituting.

i tried a serach but couldnt get any help. please help me fix this.

It usually tells you what the invalid character is (for example 0xBA or 0x8D). Did this occur in your case?

Hi Roy,

It occurs to me as well in the join stage. What should i do ?

Datawise it loads properly hence i have been ignoring it.

Regards
Sreeni

But as Ray noted, it should also be telling you "Invalid character conversion found converting XXX to ASCL_ASCII, substituting". Without that, we're completely punting in the dark.