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

Rosalina5 161 Reputation points
2022-06-23T03:37:33.36+00:00

Hello,

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,450 questions
C#
C#
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.
10,204 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 32,426 Reputation points
    2022-06-23T06:22:16.87+00:00

    Hi @Rosalina5 ,

    First you may download the files from SFTP.

    https://stackoverflow.com/questions/49779600/sftp-to-sql-import

    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.

    Regards，

    Zoe

    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

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest