the first pic is the query that runs inside the oracle .

the second is how it should be in the ssis

i need to replace all the dates in that query to variables...

cause i want it to be dynamic