Load Table output from 1st table to another table

Question

Hello All,

Need you expertise how to insert data calculating dynamic values from one table to another table. looking for option to loop through the table where we have more than 200+ entries. Please let me know your thought how to achieve this through SSIS package. I was trying with execute SQL task but not sure how to get output including all the columns as it has to calculate the stored sql output as well. Below is the sample data in input table and expected output to insert data in another table.

Table_Structure_Input_Output.png

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.

I would recommend using a script task instead of an SQL task; The Script task is a multi-purpose tool you can use in a package to fill almost any requirement not met by the tasks included with Integration Services. This article lists Script task code samples demonstrating some of the available functionality.

https://learn.microsoft.com/en-us/sql/integration-services/extending-packages-scripting-task-examples/script-task-examples?view=sql-server-ver16

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **