System Configuration: 32 bit Windows 7 machine

Server: SQL Server 2008 R2

Background: I am trying to use the Attunity data connector with SQL Server 2008 R2 to import data from Oracle to SQL database. Using the out of the box MS SQL Server 2008 R2 Oracle oledb data connector doesn't work for our situation as it doesn't import correctly unicode characters. This is why we had to move to a new data connector. Using the Oracle provided connector we were able to get the package to work, but the MS Engineer recommended the Attunity Data Connector because it has better performance.
Working solution, but not desired: Oracle 11g data connector. (This has me to believe the Oracle_Home is setup correctly).


Name:  Attunity Error.png
Views: 919
Size:  11.4 KB

Possible solution: (ERROR: Failed to load OCI DLL)

I found the above link from this forum, but was unsure what to do for my situation as mine is 32 bit and the link primarily relates to 64 bit. As I mentioned above I believe the Oracle_Home directory is setup correctly as I am able to connect and run an SSIS package with the same configuration using a different provider. Also because of this fact of being able to run it with a different provider, I would assume permissions are configured correctly. I believe it to be a configuration issue with possibly the registry, but I'm not sure where to look.

Failed solutions: Uninstalling and reinstalled Attunity 1.2 connector.

Thanks for you help in advance,

Similar post on MSDN: