DSXchange

Hi,

In my jobs i am using two oracle stages. one is source and other one is Lookup. In source column Datatype is Decimal and lookup column datatype is varchar.
Please help me out.

it works fine with decimal and varchar column lookup.

With Server, everything is basically a string under the covers. Simply use it as is or do math on it (+0) to do an implicit conversion to decimal.