CODEWITHSUNDEEP
ssissftpwinscp
siddhesh
siddhesh

Reputation: 41

SSIS Package to move files from one folder to another folder in SFTP (WinSCP) (SFTP Task for SSIS)

I want to move files from one folder to another folder in SFTP (WinSCP). How shall I design the SSIS package?

  1. help me to connect WinSCP using SSIS package
  2. What shall I use in batch file/custom code?

Upvotes: 0

Views: 872

Answers (1)

Martin Prikryl
Martin Prikryl

Reputation: 202494

To move files from one folder to another, use the WinSCP mv command:

mv /source/folder/* /dest/folder/

Add this command to WinSCP script file and run WinSCP from the SSIS.

For details, see SFTP Task for SSIS.

Upvotes: 0

Related Questions