In SSIS(2012 specifically) there is an option in the Flat File Datasource to skip a number of lines at the beginning of a file. The preview appears correctly. However, when trying to execute the data flow, it appears that those rows are still being validated; so that if they contain invalid data(blank rows), the datasource fails. This prevents using a conditional switch to remove rows, since the data flow never starts.
Is this accurate description of the normal functioning and is there any way to work around it?
Sample data looks like -
COL1|COL2|COL3 abc|123|10 def|456|20 ghi|789|30