title: Multiple DB Objects from Multiple flat files in SSDT/SSIS For Each Loop Container
body: <p>I'm very new to SQLSever/SSDT/SSIS etc, but not SQL or programming in general. From reading on the web I have been able to build myself a loop program in SSDT/SSIS that reads in all flat files in a directory and creates a database item.</p>
  
  <p>The only issue is I am not sure how to set up a connection string/parametrise the database part of the loop. When I execute the package to run I can see from the job log that it is looping through the flat files as expected, but it is loading everything into a single DB object.</p>
  
  <p>I am unable to find anything online that tells me how to create DB objects sequentially the are named the same as the flat file read in. Does anyone know how to do this?</p>
  
  <p>I'm not even sure at the minute how to grab code from the package to post on here, so if anyone could assist, I would appreciate it.</p>
  
  <p>Thanks </p>