Hi, We are having a SSIS package which is executed at 5.00AM. The package will look for the availability of the data (generally data is available in the source system by 5.30AM). After the availbilty of data it is pulled loaded into the destination. Requirement is , if there is no data available in source system then the package after waiting for 1 hr(say 6.00AM) should get terminated. This need to be implemented inside the package or the package is scheduled in SQLServer agent, so this should be implemented in the SQL server agent. Need your suggestion on how to approach it either in the package or in the Agent. Thanks Regards Jim

Hi, you can schedule the job to run every 10 min from 5.00AM till 6.00AM and change the package to check if data is available at the beginning (and if not, do nothing). David.

What is the source? If it's a file you could also use the WMI task with a timeout of 60 minutes.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

What is the source? If it's a file you could also use the WMI task with a timeout of 60 minutes.Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter