title: SSIS: Get any flat file source from folder and cache the name as a super global variable
body: <p>I'm working in SSIS and Visual Studio 2008. When executed, I need to have the SSIS package perform the following tasks:</p>
  
  <ul>
  <li>Check a folder for a file</li>
  <li>If a file exists take the file and use it as the source for the flat file </li>
  <li>Store the name of the file into a global variable that I can access in other parts of my package</li>
  </ul>
  
  <p>The package will be run by some other script. Thus we need it to check for the file every time the package runs. We are trying to prevent the scenario where we have to monitor the folder and execute the package manually when the file appears. </p>
  
  <p>Any suggestions? </p>