Anybody have good references that can guide me through this process? I'm trying to set up a connection from SSIS VS 2008 selecting ADO.NET/.Net Provider/OracleClient Data Provider and putting in the server name and username and pw and when I click on "Test Connection" I get this message. "ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"?
Here's a little context of my set up. My machine is a 64bit and the server that has the Oracle DB is also 64bit. I'm running Win 7 Enterprise. The Oracle server is Win 2008 r2 standard.