I'm creating an SSIS package in Business Intelligence Studio which takes a csv file and loads it into a database table.
The csv file is dumped on a network share on a weekly basis.
I want to schedule a job that automatically runs an SSIS package that loads this file into the database.
The problem is that the name of the file changes on a weekly basis
Is it possible to create a Connection Manager that can accomodate these file name changes?