How do I append records to a table via SSIS?

Question

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

samueloommen Newbie Points: 3 More actions · Answer 3

use lookup transformation in ssis tool

table can be appended

Phil Parkin SSC Guru Points: 246987 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

You can lead a horse to water, but a pencil must be lead.
Stan Laurel