how to use the same variable twice or use 2 different variables in ssis package ole db source editor or use 2 different variables

Question

I m trying to join two tables together and use the OLE DB Source in my SSIS package. I have two solutions here:

1. use the same variables twice in the query;
2. use two variables in the query.

I tried something like:

select     r.*, u.* 
from       recruiter r 
inner join users u on r.userid= u.userid 
where      r.modifieddate > ? 
or         u.modifieddate > ?

in my OLE DB Source Editor but apparently it's not working the way like Execute SQL Task. What should I do to make this right?

Answer 1

Name your parameters in the mappings dialog 0 & 1.