• It will only read the flat file with the name configured in the flat file connection manager.

    Since all files in a folder have unique names, you read only 1 file.

    In order to read multiple files, you need to use a for each loop and set an expression on the flat file connection manager.

    Looping over files with the Foreach Loop

    There's also the multi flat file connection manager. I've never used it, but I've read some blogs who suggest to avoid it.

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