SSIS : Read Excel File too lines -

i work on ssis project (visual studio 2012) browser send me excel file articles. informations begin in a2, until column g. use select * [produitsfamilles$a2:g] problem is, saw in file last line 16143 (under empty cell) , when run it, gives 16382 lines ... 200 lines empty crush import in database cause primary key can't empty. think it's because before send file, browser delete old unless row.

using "conditional split" give responce want know if can break directly empty row, using clause...

ssis handle excel files , stop @ empty row automatically if choose table instead of sql statement. believe select specific columns in select clause of sql statement instead of defining range in clause. ssis assumes there header row, though can specify this.

there possible issue, cells can active , empty in excel instead of inactive. test this, press ctrl , down arrow @ top of full column in sheet. should stop @ last cell data in (the 16143th row in case); if instead goes down 16382th row, you'll know have bunch of empty active rows need taken care of before importing.

in general, it's lot easier use .csv files ssis excel files, tend have these types of formatting issues.