Another bit of info that will help you get a useful response would be why you need the file list to begin with. The first thing that popped into my head on seeing your question was that you could use a ForEach loop in SSIS. Not that SSIS is your solution, but that a narrower definition of your problem will get you closer to a workable answer.