Solved the issue with by using the ? in my where clause and passing my variable to the parameter mapping in the execute sql task. Thanks

Yes your suggestion for the SQL Agent Job to run a process periodically to check if conditions are met is a great idea, I will try some testing in SSIS...

they check their logs files to determine when the data is loaded in the oracle database. I already know that the completion times are different from the logs. Are you...