Safe File Transfer via WinSCP in SSIS

The below steps help you to transfer a file to FTP or SFTP server using WinSCP tool in SSIS package:

Step 1: First download and instal WinSCP tool in your system.

Step 2: Create an SSIS  with Execute Process Task.

Step 3: Create a batch text file (e.g., WinScp_UploadToSFTP.txt) with below commands:

         ------------------------------------------------------------------------------------------------------
        option batch on
        option confirm off
        open sftp://User:password@server -hostkey="ssh-rsa..."
        lcd G:\\ECWorkArea\\Sales
        option transfer binary
        cd MDRUser
       Put *.xml
      close
      exit
-------------------------------------------------------------------------------------------------------------

The above code will load all XML file in th ementiond location to th eSFTP site.


Step 4: Configure Execute Process Task as shown below:

            Executables: C:\Program Files (x86)\WinSCP\WinSCP.com
            Arguments: -script="G:\ECWorkArea\Sales\WinScp_UploadToSFTP.txt"