Update Record

  • When im inserting a record

    If record exists in destination table ? How to Update the Record using ssis 2005?

  • 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

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

    follow this link

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

  • 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.

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

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