SSIS FTP - Download large data files

Asritha Vura 20 Reputation points
2023-02-02T17:18:37.03+00:00

I have a requirement at work where we have to move large csv/Excel data files from vendor FTP Server to our local server. I have been researching on this and thinking to use SSIS FTP Task for this requirement. Can SSIS FTP Task handle large data files? How much large data can be supported with SSIS FTP Task.

Large file size transferring recommendations that you can think of.

Any suggestion in this regards would be appreciated. This will help us in deciding the right way of achieving this requirement.

Thanks in advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,487 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,645 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 40,661 Reputation points
    2023-02-03T06:00:44.5833333+00:00

    Hi @Asritha Vura

    Actually, in official documentation, it does not mention the limitation of large data files in FTP Task.

    Reference: FTP Task

    You may have a try to see if the FTP task could meet your requirement or not.

    Regards,

    Zoe Hui


    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.