Hi everyone
I am trying to create an SSIS package that will access an SFTP site. SSIS has an FTP task but no SFTP. I read online that SSIS does not support SFTP directly. Has anyone ever set up SFTP in SSIS? If yes how did you do it? I am new to SSIS so I am learning by doing.
Thank you
If you don’t want to code it yourself you’re going to have to use a 3rd party task like cozyroc (https://www.cozyroc.com/ssis/sftp-task) but be prepared to pay a pretty penny.
Otherwise you install FileZilla or some other sftp client and then you use command tasks or script tasks however you feel comfortable to then go and execute the command line version of FileZilla to perform the transfer.
Similar to this
https://www.mssqltips.com/sqlservertip/3435/using-sftp-with-sql-server-integration-services/
January 19, 2022 at 12:46 am
wow! so expensive. pass!
I will code it as you suggested.
January 19, 2022 at 3:37 pm
Winscp is another decent option for the FTP client.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
January 19, 2022 at 6:33 pm
and winscp can be used within c# code - recommended way to use it - https://winscp.net/eng/docs/library_ssis - or alternatively use it as a process task https://winscp.net/eng/docs/guide_ssis
January 21, 2022 at 5:17 pm
We bought CozyRoc at a previous job. It worked well. I later found another similar product for about 1/2 price, but don't remember the name.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply