Microsoftlupji We managed to get ours working by using the Oracle installer on the server. Previously we had just copied the instant client files and set up the Environment Variables (TNS_ADMIN) manually. This usually works on other servers for .NET apps etc so we didn't have any reason to believe it wouldn't work for SSIS. Anyway, we used the Oracle 11g installer - 64bit (and strangely were able to still select the 'instant client' option). Then just add TNS as usual and working fine. If you look in the oracle folder created by the installer, there are a few more folders and files compared to the 'bare bones' instant client we normally copy onto our servers.
As described before, for reasons beyond our control, we're targeting SQL 2014 and Oracle 11g with version 3 (64bit) of the attunity drivers.
