• Just to be clear, are you trying to control the number of rows loaded when the data flow task executes?If you put the data flow task inside a for loop, that won't have any impact on how many rows are loaded for each loop - it only controls how many times the data flow task is executed. If you want to limit the number of rows loaded in the data flow, you'll likely need to use row numbering (as I described in this article) and filter out those rows with a row number higher than the number of rows you want to load.

    I hope this helps!
    Tim

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