If I understand you correctly:

Use the ‘Transform data task’ to insert new rows and an update query in an ‘Execute SQL Task’ to update existing rows.

Create a DTS package with ‘Execute SQL Task’ and ‘Transform data task’