Update and Add new rows with DTS

[girky]

Hello,
I'm trying to create a DTS package that updates a table in one database (A) from a table in another database (B) and also adds new rows. I've been able to populate the table in B with the original data, but I can't figure out how to make an update statement with a DTS. And I think I'd have to have a separate insert where not in statement too. Can and how do I do this all in the same DTS?
I'm really new to this and can't figure it out.

Thanks for the help!

 

[girky]

Sorry I misworded my post...the tables are in different servers.
And also I can't just do a delete on the table and replace with updates rows since I have an identity field that is created in the new table that must stay the same.