title: SSIS: The For Each File enumerator is empty
body: <p>I have a package I created that runs fine in Visual studio.<br>
  The package uses a for each file loop and the variable points to a folder like this:  </p>
  
  <blockquote>
    <p>C:\Users\Desktop\Folder\</p>
  </blockquote>
  
  <p>However, once I deploy the package on SSMS, when I execute the package I get the following error:  </p>
  
  <blockquote>
    <p>Foreach File in Folder:Warning: The For Each File enumerator is empty.
    The For Each File enumerator did not find any files that matched the
    file pattern, or the specified directory was empty</p>
  </blockquote>
  
  <p>Why do I get this warning in SSMS, but in VS it runs fine?  </p>
  
  <p><strong>Note</strong>: The SQL Server is not hosted on my local machine.</p>