I have an SSIS build that runs an "Execute SQL Task" in Control Flow, The Execute SQL Task pulls a date from the database. In Data Flow I have a DataReader Source object that queries a DB2 database table where the entry date is greater than the variable I get from the "Execute SQL Task".
How do I pass the variable from the "Execute SQL Task" to the SQL statement in the DataReader Source object in "Data Flow"?
My Data Flow source reader SQL statement is
Select * from <tablename> where entrydate > @User::iDateLoadRange
The above SQL statement will not validate.