package running fine with development environment 32 bit. but in 64 bit environment it throws the following error Code: 0xC0208236 Source: DFL_CountryLoad LKP_SEQ_LOAD [1534] Description: input column "CONST" (1548) and reference column named "LKPKEY" have incompatible data types. End Error Error: 2011-06-30 17:02:44.37 Code: 0xC004701A Source: DFL_CountryLoad SSIS.Pipeline Description: component "LKP_SEQ_LOAD" (1534) failed the pre-execute phase and returned error code 0xC0208236. End Error . I have tried to lookup oracle table. Even self look up to the same table gives this error. i have used oracleDB provider for oracle. please reply me if any one faced this type of error.

In your Package Properties, set the "Run64BitRuntime" property to False (on the Debugging tab). Todd C - MSCTS SQL Server 2005 - Please mark posts as answered where appropriate.

I do not believe the Run64BitRuntime is going to solve this issue. Balag, can you shed more light please on how you run your package in the 64 bit env? Do you use a SQL Agent? And if so did you tick on the option to instruct it to run in 32 bit mode? Also I do not understand what you did to "lookup oracle table", did you use a SQL*Plus utility on the server, or what?Arthur My Blog

Hi Arthurz, Thanks for the reply. I run using DTEXEC in 64 bit environment. the same package runs in 32 bit. but in 64 bit during run time. it throws incompatible data types error in lookup. I was using oracle table as my reference table in lookup. please let me know any thing could be done Thanks Bala

Hello Bala, It seems the issue is in absence of the 64 Bit Oracle driver. But try this: Run this package in 32 bit mode. using the 32 Bit version DTEXEC, (this is why I asked how you run). see this article http://msdn.microsoft.com/en-us/library/ms162810.aspx in there: On a 64-bit computer, Integration Services installs a 64-bit version of the dtexec utility (dtexec.exe). If you have to run certain packages in 32-bit mode, you will have to install the 32-bit version of the dtexec utility. To install the 32-bit version of the dtexec utility, you must select either Client Tools or Business Intelligence Development Studio during setup. By default, a 64-bit computer that has both the 64-bit and 32-bit versions of an Integration Services command prompt utility installed will run the 32-bit version at the command prompt. The 32-bit version runs because the directory path for the 32-bit version appears in the PATH environment variable before the directory path for the 64-bit version. (Typically, the 32-bit directory path is <drive>:\Program Files(x86)\Microsoft SQL Server\100\DTS\Binn, while the 64-bit directory path is <drive>:\Program Files\Microsoft SQL Server\100\DTS\Binn.) Arthur My Blog

Hi Arthur, I get the following error when i run it in 32 bit mode from 64 bit machine Error description : SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider OraOLEDB.Oracle.1 is not registered. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Thanks Bala

You need to install the Oracle driver thenArthur My Blog

i have installed oracle 64 bit client. it will automatically install oracle driver right... Do i need to install oracle 32 bit ?

Try with 64 bit first please, if does not work then the 32 one.Arthur My Blog

i have windows 2008 server, oracle 64 bit, sql 2008, Attunity 64 bit provider for oracle in my server i have tried running the package it throws error only in the look up component with incompatible datatype. I have got the below link but it does not help me. but the same package runs in 32 bit in my development environment. https://connect.microsoft.com/SQLServer/feedback/details/276217/ctl00_MasterBody_tsCustomerInteractionTabs if you have any other option please let me know

Switch to 32 bit modeArthur My Blog

Balag, I assume you have just got the 64 bit drivers installed on the server running the package and no 32 bit equivalent thats the reason for thsi error As you are trying to run the DTEXEC from 32 bit environment, it expects corrsoponding 32 bit oracle drivers to be installed as 32 bit drivers only would be loaded on to the runtime, thats procesiley the reason i think you face the error Though on your error i think this is an issue of conversion on data type which is common in Oracle drivers, why dont you use a data conversion component which would make the data types as obtained from Orcale source and then compare the data with your local tables, Abhinav

Hi Abihav, The datatypes are same i am using self lookup (reference table is same). for the package to run in 64 bit envirornment do i need to install any other thing other than windows 2008 server, oracle 64 bit, sql 2008, Attunity 64 bit provider for oracle because i have created the package in 32 bit environment and it is working fine in dev environment (32 bit). thanks Bala

I can understand that, as i said earlier i see this as a drivcer compatibilty problem rather then anything else. Let me know , the datatypes on the metadata from the source, and what is it like in the refernce dataset query, do they both look the same on the ColumnMapping tab of the lookup ie. the source and the refernce query columnAbhinav

both source and reference query column have DT_STR length as 7.

Finally got it working. i have installed 32 bit oracle client in 64 bit environment and ran the pacakge in 32 bit mode. ie C:\Program Files (x86)\....\Dtexec. it is working fine.