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,406 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.
9,933 questions
0 comments No comments
{count} votes

Accepted answer
  1. ZoeHui-MSFT 30,411 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 No comments

0 additional answers

Sort by: Most helpful