I have developed a SSIS package in which it contains one execute SQL task,data flow task for retrieving data from oracle and push it to SQL and one more sql task. These all tasks are present in Sequence container.
We scheduled a job to run the ssis and it was running fine in dev but where as in Production for some reason it got stuck by 2 days and no error is being shown.
Is there any chance of setting the timeout for the entire package so that after that particular interval of time I would log the error as Timeout and send mail to the respective users.
Please help me in this regard.
Thanks in Advance.