title: Check for multiple files
body: <p>Okay, I'll try to explain as good as I can... Quite a particular case.</p>
  
  <p>Tools: SSIS 2008</p>
  
  <p>We have a control flow that now needs to be <strong>triggered</strong> by an event: the presence of one or multiple files. (1,2 or 3)</p>
  
  <p>The variables used:</p>
  
  <pre><code>BO_FileLocation_1
  BO_FileLocation_2
  BO_FileLocation_3
  BO_FileName_1
  BO_FileName_2
  BO_FileName_3
  </code></pre>
  
  <p>There can be one, two or three files: defined in above variables. When they are filled in,
  they should be processed. When they are empty, this means there's just one file file, the process should ignore them and jump to the next (file watcher?) task.
  For example:</p>
  
  <pre><code>BO_FileLocation_1= "C:\"
  BO_FileLocation_2 NULL
  BO_FileLocation_3 NULL
  BO_FileName_1= "test.csv"
  BO_FileName_2 NULL
  BO_FileName_3 NULL
  </code></pre>
  
  <p>The report only needs one file.</p>
  
  <p>I'd need a generic concept that checks the presence of these files, it could be more generic than my SSIS knowledge can handle right now. For example handy, when there's a 4th file in the future. I was also thinking to work with a single script to handle all the logic.</p>
  
  <p>Thanks in advance</p>
  
  <p>A possibly irrelevant image:
  <img src="https://i.stack.imgur.com/XI4q3.jpg" alt="enter image description here"></p>