question

bk-4602 avatar image
0 Votes"
bk-4602 asked bk-4602 answered

How to copy files between two servers

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
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

YitzhakKhabinsky-0887 avatar image
0 Votes"
YitzhakKhabinsky-0887 answered YitzhakKhabinsky-0887 edited

Hi @bk-4602,

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

bk-4602 avatar image
0 Votes"
bk-4602 answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.