Hi All, As per my current requirement, I need to execute the SSIS package whenever trigger file is available at particular folder path. SSIS package executed should be trigger based and not on time based. Please let me know how to achieve this through SSIS. Thanks for your help ! Regards, Vaibhav

Create a master package that polls for your trigger file if it finds file then execute yout package else insert a delay and continue to loop. You can use a script task or a foreachloop Spandan

I think you are saying you need to watch for a file as to on its arrival execiute the SSIS package, Filewatchertask can be used to acheive thisAbhinav

Hi, I was able to achieve the result through for loop and script task as I dont want to depend on third party tasks. Thanks Spandan for your direction. Regards, Vaibhav