SSIS: Move file to archive folder and rename incrementally
Posted on 2013-11-06
I've created a basic File System task that moves a file after some other SSIS tasks have finished with it.
The issue is I want to move files with the same name on a daily basis to an archive folder but I get a failure since obviously I didn't select to overwrite the existing files in the File System task configuration. The source file name is a variable.
Is there a way I can just increment the file I'm moving by some number or use the current date so I can keep all files after they've been processed? Or is there an even alternative better way of doing this?