header row to skip RRS feed

  • Question

  • I have a flat file which exported from other system which has header for every page.

    I use header row to skip which only works the report header which shows once.

    I would like to know is it possible to skip header for every page or even can skip configurable header rows.

    Your help and information is great appreciated,



    Friday, November 8, 2013 1:50 PM


  • 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

    • Proposed as answer by Mike Yin Tuesday, November 12, 2013 3:45 PM
    • Marked as answer by Mike Yin Sunday, November 17, 2013 2:23 PM
    Friday, November 8, 2013 2:49 PM