Thanks for the question and using MS Q&A platform.
The error message you’re encountering suggests a connection issue with the SFTP server when using Azure Data Factory. Here are some steps you can take to troubleshoot the problem:
- Check Authentication: Ensure that the private key content is correctly encoded. If it’s fetched from Azure Key Vault, verify that it’s base64 encoded.
- Port Configuration: Confirm that the port number is correct and that it matches the one used by WinSCP. The standard SFTP port is 22, but your configuration might use a different one.
- Firewall Settings: Check if the necessary port range (1024-65535) is open for data transfer under passive mode, as required by Azure Data Factory.
- Server Compatibility: Verify that the SFTP server supports the operations you’re trying to perform. Some servers may not support certain features like renaming temp files.
If these steps don’t resolve the issue, consider consulting the Azure Data Factory documentation for more detailed troubleshooting
Hope this helps. Do let us know if you any further queries.