DTS and Co Question?

How can i copy data from one db1 table a to db2 table b?
1) all new data should be inserted
2) all other data should be updated
(ID's should be the same in both db-tables)
thx, mfg DanielHow do you want to update the data?
If want to update just by TSQL then First run Execute SQL Task to update
the data and then as next step run transform data task it will append
the data.
Regards
Amish
*** Sent via Developersdex http://www.developersdex.com ***