title: SSIS - Polling Files Folder and Trigger ETL Packages
body: <p>Need advice, see below scenario</p>
  
  <p>We have developed 1 ETL Package which can process 5 files at one time (which usually takes 1 mins). We expect that nearly 100+ files can come to the PROCESSING folder during morningtime (means lets say between 6 am and 7am).</p>
  
  <p>I'm struggling to design/develop some sort of polling mechanism, which keeps looking for files and if they arrive it will trigger ETL package (trigger through SQL Server Agent job).</p>
  
  <p>How to do polling and then triggering that ETL Package - is Service Broker will help </p>
  
  <p>I'm new to SSIS so need advise. Need to find solution within SQL Server rather than developing .net app to poll for folders and then trigger jobs</p>
  
  <p>Regards</p>