I am trying to automate a files copy rename from source SharePoint Document Library to a Destination SharePoint Document Library
There will be about six files posted once a week to source folder with the same name every week and will overwrite the file in the folder.
I need to copy and rename the files to the SharePoint Document Library archive folder before they will be overwritten and add the file date to the file name
The reason fro SSIS is because that is all that I am aloud. I just have bids 2005.