Update Record

Question

Update Record

satishthota

SSC Eights!

Points: 959
More actions
July 28, 2008 at 4:57 am

#122607

When im inserting a record
If record exists in destination table ? How to Update the Record using ssis 2005?

Viewing 4 posts - 1 through 3 (of 3 total)

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

hodgy SSCertifiable Points: 5906 More actions · Answer 1

Currently, there is no inbuilt update functionality within SSIS 2005 (I think there is something coming in SSIS 2008 to deal with this).

The only way is to write the new values to a holding table and use a SQL task to join the destination and the holding table and update accordingly.

Tom

Life: it twists and turns like a twisty turny thing

mcdonough_martin Newbie Points: 9 More actions · Answer 2

you're looking at a incremental load, involving a lookup and a conditional split

follow this link

http://www.sqlservercentral.com/articles/SSIS/62063/

Dave Klug SSCertifiable Points: 5811 More actions · Answer 3

If the amount of data you're dealing with is small (few hundred thousand rows), the lookup, condition split will work. For larger data volumes, use the staging table and then include a SQL task for the insert/update. This will allow for set based updates rather than row-by-row.