title: SSIS Foreach loop container dynamic file name and path , then unzip files
body: <p>I have a folder having multiple files with the name as </p>
  
  <pre><code>P04_20140326_1234.zip
  P04_20130324_58714.zip
  P04_20130808_jurhet.zip
  P04_20130815_85893.zip
  etc
  </code></pre>
  
  <p>The name is in the format P04_systemdate_*.zip.</p>
  
  <p>I want to pick the folder containing currentdate in the name and unzip it first and load the data from extracted file into the table.eg : file named as A.txt goes into table A, filenamed as B goes into table B and so on...</p>