Copying file from one server to another
Posted on 2014-02-22
I have the names of file path in a MS SQL 2005 table in the following format:
These can be dumped into a flat file called processfiles.txt residing on the SQL server, which would contain the following contents:
I wanted to write a batch script that will reside on a different server than the SQL server and will need to copy those files in the table and put them on a folder on the current server.
How do I accomplish this?