Here is my process that I am doing in SSIS…moving data from source system to destination system on daily basis. So far I have been doing this task manually by checking the timestamp on the source system and destination system and run SSIS package only if source timestamp is greater than destination timestamp. But now I would like to automate this process. I would like to schedule a job in SQL Agent and run it on daily basis where SQL Agent will only run the job if the above mentioned condition is met. My question is how do I put this logic in SQL Agent to check for this condition? Thanks in advance.

You better put this logic into the SSIS package. Reason is this way the package becomes a single logical unit of work. To check you can use a LookUp and to decide if to run or not you can employ the Precedence Constraints. Arthur My Blog