SSIS SFTP:如何解决“无法上传:套接字读取操作已超时"? [英] SSIS SFTP : How to resolve "Unable to Upload: Socket read operation has timed out"?

问题描述

使用 SSIS SFTP扩展并正确配置所有内容.

Using the SSIS SFTP Extension and configured everything correctly.

但是，我每次执行SFTP任务时都会遇到以下错误:

However, I'm getting the following error any time I execute the SFTP task:

错误:错误:无法上传:套接字读取操作超时

Error: Error: Unable to Upload: Socket read operation has timed out

在SSIS.Extensions.SFTP.SFTPConnection.ThrowException(字符串消息，例如，异常)
在SSIS.Extensions.SFTP.SFTPConnection.UploadFiles(列表1个文件列表)
在SSIS.Extensions.SFTPTask.SFTPTask.Execute处(连接连接，VariableDispenser variableDispenser，IDTSComponentEvents componentEvents，IDTSLogging日志，对象事务)

at SSIS.Extensions.SFTP.SFTPConnection.ThrowException(String Message, Exception ex)
at SSIS.Extensions.SFTP.SFTPConnection.UploadFiles(List`1 fileList)
at SSIS.Extensions.SFTPTask.SFTPTask.Execute(Connections connections, VariableDispenser variableDispenser, IDTSComponentEvents componentEvents, IDTSLogging log, Object transaction)

我必须能够通过隐式SSL 进行连接.

I have to being able to connect via Implicit SSL.

有几个付费的SSIS组件可以解决这个问题，但是我不愿意为它们付费，因为它们包装了许多我不需要的其他组件，因此价格昂贵.

There are a couple of paid SSIS components that will do the trick, but I'm not willing to pay for them as they're expensive given they package a slew of other components I don't need

推荐答案

SFTP不使用TLS/SSL(既不是隐式的也不是显式的).显式/隐式TLS/SSL与FTP一起使用.

SFTP does not use TLS/SSL (neither implicit nor explicit). Explicit/Implict TLS/SSL is used with FTP.

换句话说，SFTP不是基于TLS/SSL的FTP.这是一个完全不同且不兼容的协议.

In other words SFTP is not FTP over TLS/SSL. It's a completely different and incompatible protocol.

因此，您可能试图使用SFTP组件连接到隐式TLS/SSL FTP端口(990).那行不通.

So you are possibly trying to use SFTP component to connect to an implicit TLS/SSL FTP port (990). That cannot work.

• 确保您知道需要使用哪种协议
• 如果事实证明您需要使用FTP，请使用具有TLS/SSL加密功能的FTP任务.

这篇关于SSIS SFTP:如何解决“无法上传:套接字读取操作已超时"?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！