title: Dynamic table create and load data in ssis
body: <p>I have small doubt in ssis, text file have  location data based on location need to create table dynamicaly in sql server and load related location data using ssis package,
  source text file have sample data like below</p>
  
  <p>id | name  |  location
  1  | abc   |Hyd
  2  | banu  |chen
  3  |  jai  |bang
  4  | hari  |Hyd
  5  |nani   |Hyd
  6  | banti |bang
  7  |kali   |chen</p>
  
  <p>based on this text file load we need to create  location tables dynamically and load related data.because of some time may have more location in text file that situation we need to create table dynamically and load it.please tell me how to achive this task using ssis.we need foreach loop container but don't how to achive this.please tell me  to solve this issue</p>