How to copy files between two servers

bk 461 Reputation points
2021-09-02T14:11:46.923+00:00

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

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,496 questions
0 comments No comments
{count} votes

Accepted answer
  1. Yitzhak Khabinsky 25,566 Reputation points
    2021-09-02T14:48:50.793+00:00

    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.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. bk 461 Reputation points
    2021-09-02T16:39:40.013+00:00
    0 comments No comments