I am using Data Flow task for the below query.

I have a source connection as MyOrclConn which uses Oracle Provider for OLEDB.
I am trying to write a query which selects the records from Oracle based on
the RunDate that is in Audit_Date in SQL Server Db (MySqlSvrConn).

My purpose here is to get the new records since last run from the source db.
So I want to write something like this.

SELECT * FROM OrclDB.MyOrclTbl
Where MyOrclTbl.DateModified > (Select RunDate From SqlSvrDb.dbo.Audit_Date)

My understanding is since I have selected Oracle connection it can
understand only Oracle syntax and objects. So it is unable to get the value
from Audit_Date.
How can I do this? Do I need to use Parameter? Or something else? How do I
do this?

Thanks!