I am trying to take data from a table in one database and add it to an existing
table in another database. The both use the same primary key. I set up a
package to pull the data from the source database but not sure how to update
the table with the seleceted data.

The source table from db1 is

Key1, Info

The destination table in db2 is

Key1, info

The info in db2 is empty but needs to be populated with db1 info without
deleting what's there.

If I use an oledb destination from an oledb source how would I create an
update statement to update db2