I have SS on 64bit trying to do a lookup to an Oracle 10G db - I'm reading from a SS table and using a column to be part of the 'where' clause on my lookup against a table in oracle - I get Data Type mismatch even though both columns are strings (the input SS column is mapped to a string Derived column which is then mapped to the lookup). If I run on a 32bit machine it works fine. Ihave a task that can successfully update the Oracle DB table (on 64bit), I just can't get the lookup to work on 64 bit. Anyone else seen this? Thanks

i am facing the same problem. package was running in 32 bit environment with no issues. when i run the same package in 64 bit envirornment it was showing incompatible data type error in lookup component. look up was with oracle table . if any one had faced this issue and resolved it. please reply back.....

try converting it to Unicode i have faced similar issue when transferring data from oracle to SQL Server and it was always a pain because of Unicode and non Unicode try using DT_WSTR it should work fine http://msdn.microsoft.com/en-us/library/ms141036.aspx-------------------------------------------------------- Surender Singh Bhadauria