title: SSIS: Why when I add expression variable to Connection Manager properties I lose connection?
body: <p>I have a SSIS package that needs to enumerate <code>Excel</code> files in <code>Sharepoint</code>.  When I setup the <code>For Each</code> loop container at the package level and then set up the file path in my <code>Excel Source</code> at the task level everything is fine.  When I add my expression variable to the <code>Excel Connection Manager</code> properties I lose the connection and can't view my input table anymore.  I have <code>"Delay Validation"</code> set to <code>true</code> on the <code>Excel Connection Manager</code>.</p>
  
  <p>Has anybody experienced this?</p>
  
  <p>EDIT:</p>
  
  <p>The following are screenshots of my <code>ForEach Loop Container</code> configuration:</p>
  
  <p><img src="https://i.stack.imgur.com/hF1zA.png" alt="enter image description here"></p>
  
  <p><img src="https://i.stack.imgur.com/7KFsz.png" alt="enter image description here"></p>
  
  <p>The following is a screenshot of where I am passing the variable.  It is in the Expression box of the Excel Connection Manager:</p>
  
  <p><img src="https://i.stack.imgur.com/SeHpt.png" alt="enter image description here"></p>