While using FTP wizard in SSIS getting error "Server name credentials,port may be invalid". However I am using same credentials ,server name and port on Winscp it's working. * I am using Port : 22 (SFTP) Please suggest what to do? Thank you !
Asked
Active
Viewed 32 times
1
-
2FTP and SFTP are not the same. You can't use FTP to connect to an SFTP server. SSIS does not support SFTP natively, so you will need to use a custom script/task/command line execution/etc to use SFTP. – Thom A Jan 22 '19 at 09:57
-
Thank you, do you have any sample for this one that you may share with me ! that will be very helpful !!! – usama.nomani Jan 22 '19 at 10:05
-
Personally, I use [PSFTP](https://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html), and then call the executable using an Execute Process Task, passing the necessary parameters/switches. – Thom A Jan 22 '19 at 10:11
-
1Since you already are using WinSCP, you could just follow their tutorial for using it in an SSIS Script Task: https://winscp.net/eng/docs/guide_ssis – digital.aaron Jan 22 '19 at 21:18