I'm a newbie to using SSIS for data imports - I have a couple of files that I want to import into my database schema, but I'm going to need to run this once every 3 months; the file names change based on the quarter e.g. SKU1QTR
will become SKU2QTR
.
How can I handle a situation like this with SSIS? Is there a way to specify the file names (there are at least 6 files like this) or, better yet, just specify the numeric portion since the rest of the file always stays the same?