How to copy files between two servers

Question

Hi All
I want to copy around 30 files on a daily basis from SERVER-A to SERVER-B. I looked at the file system task , it does not give the option to give the server name, if i am on Server-A and create a package and drop the file system task , in the destination connection there is no where we can enter the Server-B info. Please advice.
Thanks

Answer 1

Hi @bk ,

Files belong to the file system directories. It is impossible to "...copy files between two servers...".
What needs to be done:

• Create network file shares for local directories exposed as UNC (\server\fileshare\directory) on both servers.
• Define proper permissions for UNC file shares.
• Copy files between network file shares via SSIS File System Task.

Answer 2

@Yitzhak Khabinsky Thanks.