Skip to main content
kavyashreeh3453
July 4, 2023
Solved

Rows allowed for SFTP transfer in CSV

  • July 4, 2023
  • 9 replies
  • 0 views

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?

Best answer by kavyashreeh3453

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

9 replies

mathieud0001
Brainy
July 4, 2023

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
July 5, 2023

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

mathieud0001
Brainy
July 5, 2023

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?