Oracle queries not executing in SSIS, but work in TOAD

Question

CREATE TABLE employees (
    employee_id NUMBER,
    first_name VARCHAR2(50),
    last_name VARCHAR2(50),
    hire_date DATE
);

I'm encountering an issue with executing Oracle queries within SQL Server Integration Services (SSIS). Here's the problem:

1. I have set up an Oracle connection manager in SSIS, and the connection tests successfully.
2. However, when I try to execute queries within the SSIS package using the OLE DB Source component, the queries do not seem to execute.
3. Interestingly, the same queries execute without any issues in TOAD, so I'm confident that the SQL syntax and connection details are correct.
4. The same query also executes successfully in SQL Server Management Studio (SSMS) via SSIS.
5. Additionally, when the SSIS package is executed with the Oracle connection, the query seems to keep loading indefinitely without any result.

I have already checked the following:

1. Verified the connection manager settings in SSIS to ensure they match those in TOAD.
2. Tested the connection from the SSIS package, and it connects successfully.
3. Reviewed the SQL query syntax to ensure it is compatible with Oracle.
4. Checked for any error messages in the SSIS package execution log, but none seem to be related to query execution.

I'm unsure why the queries are not executing in SSIS or why they result in indefinite loading. Are there any additional configurations or troubleshooting steps I should consider to resolve this issue?

Any insights or suggestions would be greatly appreciated. Thank you!