title: How to using the loop and bulk load tasks to insert the name of the csv files being looped?
body: <p>Description</p>
  
  <ul>
  <li>I have created an SSIS package imports data from hundreds of csv files on a daily bases</li>
  <li>I have used the bulk load and foreach loop container</li>
  </ul>
  
  <p>Problem</p>
  
  <ul>
  <li>I have created a column on a database table and wanted to know if it is possible to add the source file name on each row of data.</li>
  </ul>