title: How to load multiple files in ssis
body: <p>i am very new to ssis !</p>
  
  <p>i wanted to know the below.</p>
  
  <p>How to load multiple files into sql-server using ssis tasks?</p>
  
  <p>I am currently working on datawarehouse. i have a bunch of files each in separate folders</p>
  
  <pre><code>the folders are
  
  Myfolder
    -&gt;subfolder_21-03-2009.txt
    -&gt;Mysubfolder_21-03-2009.txt
  Myfolder1
    -&gt;subfolder_22-03-2009.txt
    -&gt;Mysubfolder_22-03-2009.txt
  Myfolder2
    -&gt;subfolder_23-03-2009.txt
    -&gt;Mysubfolder_23-03-2009.txt
  </code></pre>
  
  <p>I am able to load <code>Subfolder.*.txt</code> into sql-server DB(table 1) using <code>foreachloop</code> In ssis..</p>
  
  <p>now can somebody tell me how'd i load <code>mysubfolder.*.txt</code> into Sql-server(table 2) DB </p>
  
  <p>i want to load multiple files into sql-server in a single process.</p>
  
  <p><code>please somebody guide me !</code></p>