title: How to import/transform unstructured CSV file into SQL table using SSIS
body: <p>I've a .CSV file which comes exported from a 3rd party system in a format as below: </p>
  
  <p><img src="https://i.stack.imgur.com/9eFhZ.png" alt="enter image description here"></p>
  
  <p>The CSV file is a single report containing multiple datasets. Every dataset starts with its own column header (time, name, address etc) with blank rows between the next dataset. </p>
  
  <p>I want to extract this data into SQL Sever table using SSIS, but the problem is in the first data set 'Time' column falls into ColB and in the second dataset 'Time' column changes the column position (ColA) each time in single report and there are blank rows in between the data sets. The header (ColA, ColB...) are the column header when CSV is viewed in EXCEL.</p>
  
  <p>How this can be achieved using SSIS?</p>