• The two ways we've done this are:

    1) Writing the filenames as the contents of another file that you use as a source in the SSIS package.

    2) Writing the filenames to a SQL table that you use as a source in the SSIS package.

    ...hope this helps