I wish to strip the date from a filename that is generated from another system so that I can run a schedule DTSX packages on the file. The file is in the format SampleFile_<yyyymmdd> <hhmmss>.csv. I'd like to back this up to another folder but also rename it to a static value such as SampleFile_Current.csv so that my DTSX package can run as it depends on the filename.

Any suggestions welcome.

thanks

MC