topic Re: Data Copy to SFTP Destination Failing in Pipelines

Data Copy to SFTP Destination Failing

Anonymous — Tue, 26 Mar 2024 13:53:02 GMT

Hello everyone,

I'm currently working on a project that requires sending a CSV file to an external SFTP server. I'm exploring different methods to accomplish this task, and I've decided to try using the Data Copy activity within a pipeline to see if it's feasible.

I've attempted two approaches. Initially, I created a temporary SFTP test server using Free SFTP server: online SFTP server for testing - SFTPCloud and established a connection to it. However, when I tested the connection, I encountered the error "An internal error has occurred." I conducted this test using my personal account, which only has a trial license, as I didn't want to expose my company to an unknown server.

Subsequently, I replicated the same process using my official account, which is associated with an F-64 subscription, and the official external SFTP credentials to which I'll need to send the file. Yet, I encountered the same error.

Could someone provide insights into what might be causing this issue? Any ideas on how to troubleshoot and establish a successful connection would be greatly appreciated.

Thank you!

Re: Data Copy to SFTP Destination Failing

Anonymous — Wed, 27 Mar 2024 09:00:44 GMT

Hi Anonymous ,

Thanks for using Fabric Community.
I tried to repro your scenario -

Can you please check this format?

eu-central-1.sftpcloud.io:22

Hope this is helpful. Please let me know incase of further queries.

Re: Data Copy to SFTP Destination Failing

Anonymous — Wed, 27 Mar 2024 15:52:08 GMT

Thank you! I didn't expect the solution to be so simple.

Re: Data Copy to SFTP Destination Failing

Anonymous — Wed, 27 Mar 2024 15:53:00 GMT

Thank you! I didn't expect the solution to be so simple.

Re: Data Copy to SFTP Destination Failing

ToddChitt — Fri, 05 Sep 2025 20:40:13 GMT

What is the proper format for specifying a non-default port?

<serve rname>(:<port number>)

The latter seems to be what Fabric recommends when creating the connection:

But the former is how you suggest here.

I can't get ANY flavor to work in Fabric.

Any additional nuggets of wisdom?

Thanks