SSIS Script Task to execute INSERT statements

Question

Hi

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

Answer 1

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.

Answer 2

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