What is the fastest driver for connecting to an oracle database from SQL Server Integration Services (SSIS) ?
Will we still need to have oracle client installed (with a tnsnames .ora file) etc.
We are currently using SSIS 2012 - but could upgrade
Understand that the oracle database is at least version 11 or later.
We are currently using the Microsoft oracle driver (and have the oracle client - tnsnames.ora - installed on the SSIS server). We have been running with this for a long time , but this driver seems fairly slow, and is 32 bit - understand that when deployed the package has to run in 32 bit mode.
We are using SSDT based on visual studio 2015.
Any help gratefully received.