• You can skip n number of rows at the beginning, but there is no transformation that will allow you to skip every nth row. Is there anything in the data of those 1st and 5th rows that you could use to exclude them in the pipeline (for example, using a conditional split)?

    If not, there are a couple of things you can try. You could send the rows to a staging table and use an Execute SQL Task to delete the 1st and 5th rows, then use that staging table as a source in another data flow to send output to the destination table. You could also try, as a last resort, using the Script Task or Script Component for this.

    hth,

    Tim

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices