Reading objects from an Oracle data source results in an error message, but Test Connection to the Oracle data source works.
'No suitable Oracle driver installed'
There are two potential causes for this issue. One is that Oracle Data Provider may be a different bit version than TX DWA. The other potential cause is an SSIS conflict.
Ensure that Oracle Data Provider is the correct bit version. If there is no bit version conflict, disable SSIS for the connection. If SSIS is required for the connection, please submit a new support ticket.
Author: Doug Wynkoop