Some things to try. I don't have the environment set up to test these suggestions. I would test the results first.
First on the Flat File source, I would try redirecting the errors and truncation to an error file, including the error. I would check the error output to see what rows are output. Are the header rows that you want to exclude all being sent to
the error output? If they are, can you confirm that when a header row is sent to the output that no additional data rows are sent to the output (sometimes the parser grabs more than one row).
If these header rows are not treated as errors, is there some characteristic that would identify the row as header. For example, I assume that your rows have columns in them and some of the columns always have data if the row represents a data row
not a header row. You can use a Conditional Split transformation to remove all rows that don't have a value in them.
http://sqlblog.com/blogs/andy_leonard/archive/2009/02/20/ssis-expression-language-and-the-conditional-split-transformation.aspx. You might want to include an or clause with a test of empty string.
ISNULL(ColumnName) || TRIM(ColumnName) == ""
Russel Loski, MCT, MCSE Data Platform/Business Intelligence. Twitter: @sqlmovers; blog: www.sqlmovers.com
