SSIS Script Task to execute INSERT statements

Kuldeep Chitrakar 1 Reputation point
2021-11-26T17:54:54.62+00:00

Hi

Is there any sample script task/component for reference which can show how to write a script task for executing INSERT statements .

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
1,849 questions
No comments
{count} votes

2 answers

Sort by: Most helpful
  1. ZoeHui-MSFT 18,896 Reputation points Microsoft Employee
    2021-11-29T02:04:30.16+00:00

    Hi @Kuldeep Chitrakar ,

    You may refer below two links to see if it could meet your need or not.

    ssis-data-import-script-task

    inserting-into-a-table-using-ssis-script-task

    In addition, to insert value to table, you may also use Execute SQL Task and Execute T-SQL Statement Task.

    execute-t-sql-statement-task-in-ssis

    execute-sql-task-in-ssis-sqlstatementsource-expression-vs-variable-source-type

    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.


  2. Olaf Helper 25,726 Reputation points
    2021-11-29T09:10:48.307+00:00

    Why that complicated, why not using a simple Execute SQL Task?

    No comments