Urgent: how to get source data with runtime variable

All,

I need to pass a variable to get source data from Oracle on OLE DB source. The variable is defined by an Execute SQL task (previous step) on the control flow and it is a package level variable.

In the data flow, OLE DB source using ‘SQL command from variable’. The variable sql command works when it just: Select *from table

But I need the variable SQL command like this:

Select * from table where last_modified_date > - - variable1

the variable1 is defined by anther Execute SQL task at runtime

Can someone give some light on this

Many thanks