Design and Develop SSIS Package to TRANSFER File from SFTP to SQL Database table

Rosalina5 161 Reputation points


May someone please help me step-by-step how can I move .csv file from SFTP to SQL Table, every time when file appear in SFTP, I want to move to SQL Table.

Please help.

Thanks a lot

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,406 questions
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
9,933 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 30,411 Reputation points

    Hi @Rosalina5 ,

    First you may download the files from SFTP.

    And then you may follow this tutorial to Reject Already Loaded Files & Load Only New Files to Table.

    SSIS Tutorial Part

    You may run the package with schedule, hope it will help you.



    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

0 additional answers

Sort by: Most helpful