What would be a recommended choice of SSIS component to perform SFTP or FTPS task?

ssis ftp sftp ftps
Kevin Fairchild picture Kevin Fairchild · Sep 30, 2008 · Viewed 15.3k times · Source

Sometimes normal FTP doesn't quite cut it... When you need to do secure FTP via SSIS packages, which product would you recommend?

Before answering, please see if someone has already suggested the same thing and, if so, vote it up.

NOTE: Ideally, it needs to handle both SSH and SSL FTP connections, but I'd consider two separate components if it makes the most sense....

Answer

Martin Prikryl picture Martin Prikryl · Apr 2, 2009

Not actually SSIS component. But you may consider checking guide how to use WinSCP open source SFTP client as task in SSIS.

Related questions

How to avoid SSIS FTP task from failing when there are no files to download?

I'm using SQL Server 2005, and creating ftp tasks within SSIS. Sometimes there will be files to ftp over, sometimes not. If there are no files, I don't want the task nor the package to fail. I've changed the arrow going …

Read More
How to pass variable as a parameter in Execute SQL Task SSIS?

I have ssis package in that I'm taking values from flat file and insert it into table. I have taken one Execute SQL Task in that creating one temptable CREATE TABLE [tempdb].dbo.##temptable ( date datetime, companyname nvarchar(50), price decimal(10,0), …

Read More
SSIS Convert Between Unicode and Non-Unicode Error

I have an ssis package where I am using an OLEDB source linking to SQL Server 2005 table. All columns except a date column are NVARCHAR(255). I am using an Excel destination and using a SQL statement to create the sheet …

Read More