Rather than using a complex expression, why not use a foreach container with a filespec of Generic*.csv (on the assumption that files are moved or renamed after they have been processed)?
Sounds like you should investigate the use of SYNONYMs. Create two identical tables LARGETable1 and LARGETable2 and use a synonym to switch between them every two months (after truncating the...