Prerequisites for transferring file from MID Server to a target server

[Pranita2]

Hello,

I want to transfer a csv file from MID Server to a destination server using SFTP. Can anyone please let me know what would be prerequisites for it.

Thanks,

Pranita Bahuguni

[jonsan09]

You'll want an FTP client on your MID server and then setup a powershell script to excute the SFTP transfer, you can then trigger the powershell via windows task scheduler or via flow designer custom action.

[Pranita2]

Hi @jonsan09 

Thankyou for your reply, that is helpful. Can you please also let me know below queries on this

1. If we are transferring file from MID Server to a target server then do we have to enable SFTP on both the servers.

2. Also, if we are using Flow Designer , then is there is any method via which we can  generate the csv (data dump which need to be uploaded)

Thanks,

Pranita

[jonsan09]

For 1., you'd need one server to act as the FTP server and another to act as the FTP client.
For 2, you could setup a "System Export Set" to get the files onto the MID.