sql - SSIS package for Insert and Update -


pretty new ssis packages. need solution following data flow scenarios.

have 2 identical tables on both source , destination databases.

source table

id     | employee    ------ | ------ 1      | paul           2      | jane 3      | john 

scenario 1

destination table before insert

id     | employee    ------ | ------ 1      | paul           3      | john 

destination table after insert

id     | employee    ------ | ------ 1      | paul           2      | jane 3      | john 

scenario 2

destination table before update

id     | employee    ------ | ------ 1      | paul           2      | kate 3      | john 

destination table after insert

id     | employee    ------ | ------ 1      | paul           2      | jane 3      | john 

the ask asking upsert scenario. can follow link 1 of such implementation.

  1. inserted in order - not possible. can't re-order data while performing data loads. if still deem necessary, option need chose truncate data , load again.
  2. data updated on match

Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -