conditional split based on column names but not values

1. Use a foreach loop to loop through the files saving full file path with name to a variable.

2. Use a script task to determine if the file is for cell phones or regular phones. Note: filepath is likely a variable as well from foreach loop

   string readingLine;
   
   Using(System.IO.StreamReader readingFile = new System.IO.StreamReader(filePath))
   {
      readingLine = readingFile.ReadLine();
   }
   if(readingLine.Contains("Cell") //It would be best to use the full column name with a comma to avoid names with Cell in it to false trigger a true result
   {
      Dts.Variables("PhoneType").Value = "Cell";
   {
   else
   {
      Dts.Variables("PhoneType").Value = "Phone";
   }
   

3. Add a dataflow

4. Read the flat file skipping header row.
5. Add a derived column to add phone type from variable
6. Load to a table

After this is done you can create views for your desired output.