May 12, 2020 at 6:12 am
Hi you can use lookup common function in ssis tool box to do appending data into table.
link to use lookup
May 12, 2020 at 6:14 am
use lookup transformation in ssis tool
table can be appended
May 12, 2020 at 11:58 am
Is this a blog post, or do you have a question?
Appending to a table using SSIS is as simple as creating a data flow, from source to table, and executing it.
Lookups may be part of the solution, but by themselves will not append data to anything.
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
See https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help/ for details of how to post T-SQL code-related questions.
Viewing 4 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply