Viewing 3 posts - 1 through 3 (of 3 total)
use lookup transformation in ssis tool
table can be appended
https://www.sqlshack.com/an-overview-of-the-lookup-transformation-in-ssis/
May 12, 2020 at 6:14 am
#3750661
link to use lookup
May 12, 2020 at 6:12 am
#3750660
Hi you can use lookup common function in ssis tool box to do appending data into table.
#3750659