I have a list of files extracted from a table in a SQL database. The file can be either a delimited text file or an excel spreadsheet, whichever works best.
The file looks like this
sourcePath1\fileName1, destPath1\fileName1 sourcePath2\fileName2, destPath2\fileName2 sourcePath3\fileName3, destPath3\fileName3
One column contains the original path and filename of the files, the second column contains the desired path and filename of the files. This has been obtained using a standard REPLACE() function in the original SELECT statement.
Now I have the list(s) I actually need to copy the source file to the destination.
Is this achievable using the command line (batch or Powershell?) or via scripting or a GUI?