• If all the flat files have the exact same structure: yes. Use a For Each Loop with a dataflow inside and expressions on the connection managers.

    If they don't have the same structure: no. It's not possible. You'd need to create seperate dataflows for each flat file.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP