Skip to main content
kavyashreeh3453
Inspiring
Jul 4, 2023 4:41 PM UTC
Solved

Rows allowed for SFTP transfer in CSV

Hi,

We are trying to generate CSV with 1 million rows. But when we try to transfer files over SFTP, the file transfer fails.

For less number of rows the SFTP transfer goes fine.

What is the rows allowed for SFTP file transfer?

kavyashreeh3453
Inspiring
Jul 5, 2023 1:52 PM UTC

The issue was with multiple files loaded in the target directory. File transfer went fine after clearing the directory.

9 replies

mathieud0001
Genius
Jul 4, 2023 4:48 PM UTC

If the file transfer fails, it probably has more to do with the size of the file than the number of rows.

Do you know what the size of the file is?

kavyashreeh3453
Inspiring
Jul 5, 2023 10:35 AM UTC

All the files we are trying are less than 150 MB.

mathieud0001
Genius
Jul 5, 2023 10:45 AM UTC

OK but what are the sizes of both files (over 1M and under 1M)?

How much time does the under 1M file transfer take to complete?