How do I append records to a table via SSIS?

Question

Post reply

How do I append records to a table via SSIS?

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

samueloommen Newbie Points: 3 More actions · Answer 1

Hi you can use lookup common function in ssis tool box to do appending data into table.

samueloommen Newbie Points: 3 More actions · Answer 2

link to use lookup

https://www.sqlshack.com/an-overview-of-the-lookup-transformation-in-ssis/

samueloommen Newbie Points: 3 More actions · Answer 3

use lookup transformation in ssis tool

table can be appended

https://www.sqlshack.com/an-overview-of-the-lookup-transformation-in-ssis/

Phil Parkin SSC Guru Points: 246960 More actions · Answer 4

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.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin