I am setting up a package to impoert text files into db, the file name was changing according to date, today's file name is AMD20081116.txt and tommorrow's file name would be AMD20081117.txt. I think I need to use expression for the connection manager property but could not find where to configure it. Or should I use a script task for this purpose? any sample I can use? Thanks for your help.
I used to accomplish this through DTS dynamic property for the datasource, can not figure out how to do it in SSIS.