How can I rename a dynamic source file in SSIS
Posted on 2011-03-02
I have a CSV file XXXX_YYYYMMDD.CSV that I grab off of an FTP Site. I am looking to rename this file after I place in my directory. I am looking to rename the file to XXXX.CSV. I try to rename it using the file system task however, the file will change everyday so I do not have the proper name once it is in my directory to change it. Can anyone direct me in being able to change this dynamic file name?