title: SSIS import xls file and split it in 2, after the empty row
body: <p>I have an excel file with bunch of data separated by 2 empty rows. I need to separate this 2 data sets into two CSV files. So in SSIS Data Flow I picked "Excel Source" next "Conditional Split" and "Flat file destination". Question is how to setup split to do the job?</p>
  
  <p>Excel data example:</p>
  
  <p><p>
  Server_name | PrimarySA | SecondarySA <BR>
  srv1        | SA1       | SA1<BR>
  srv2        | SA2       | SA2<BR> 
  srv3        | SA3       | SA3<BR>
  empty row            |           |<BR>
  empty row             |           |<BR>
  srvA        | SAa       | SAa<BR>
  srvB        | SAb       | SAb<BR>
  srvC        | SAc       | SAc<BR></p>
  
  <p></P></p>