I'm new to SSIS & I need some assitance around the Flat File Manager concept.
I've designed my whole package and it works successfully; however, I found out when run it as a Job task it fails - I found the issue and it's because in the "Flat File Connection Manager Editor" the filename points to a hardcoded path & file to be inserted into our tables.
Therefore everyday that filename will change depending on Month & date so tomorrow it will be df.0920.csv .... df0921.csv.... df1212.csv & so on.
Is there any way i can have the filename changed/updated automatically to new filename through a variable or something so it gets picked up.
I've checked online & can't find exactly what I need for my scenario - there are similar ones but when i tried they didnt work.