How to use the Copy file from remote host (SCP) or (FTP) component?

I have tried both copy file from remote host (SCP) and (FTP) components to download data to my personal directory. However, when using the copy file from remote host (FTP), I will received a connection time out error message. For Copy file from remote host (SCP), the program seemed to be running a long time and not sure how long it will take to complete. The file only contains 100 rows. For the Remote file field, it's a path to a csv file (the file name is too long to see the .csv in the field). Will appreciate any help! Thank you!

Also, is there a limit on how many rows of data (in csv or excel format) that pipeline pilot will be able to process?