pmscorca (9/5/2013)
Perhaps it could be enough to install the Oracle Data Access Components (ODAC) for Windows and not an Oracle client, isn't it?However, it should be useful to know any Microsoft articles that talks about how using the Oracle data provider inside SSIS without studying Oracle documentation.
I think that this issue is common for more other developers. It is enough only setting the TSNAMES ...
When I had to migrate data from Oracle to SQL Server, I installed the client and the ODAC.
Maybe it's not necessary to install both, I shall never know 🙂
The part I struggled with most is setting the TNSNAMES.ORA.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP