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

Rosalina5 121 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.
1,857 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.
7,019 questions
No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 18,896 Reputation points Microsoft Employee
    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.

    No comments

0 additional answers

Sort by: Most helpful