I want to know whether SSIS can do SFTP. If yes, how does it work?
SSIS does not support a SFTP transfer out of the box. You would need a third party component. You can easily use a Rebex SFTP .NET library with a SSIS script task.
Welcome to Q&A forum for C# and VB.NET developers working with following .NET components:
If you need immediate assistance, please contact us directly.