How do I append records to a table via SSIS?

Question

Viewing 4 posts - 16 through 19 (of 19 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: 247180 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.