title: How do I set up a dynamic file path in SSIS for an Excel file?
body: <p>The name of the file changes based on months. Every month you have a new file. </p>
  
  <pre><code>I:\Test\Data_201303.xlsx
  </code></pre>
  
  <p>How do I set up a connection manager that will work with variable file paths?</p>