title: How do I connect to Oracle with SSIS? I am getting the error: "tns listener was not given the service_name in connect_data"
body: <p>I am trying to connect to an Oracle DB through the Oracle Provider for OLE DB in SSIS, but am getting the following error when testing the connection: "tns listener was not given the service_name in connect_data". I am not too familiar with Oracle, so could someone provide me some direction for how to fix this error?</p>