I have imported a flat file to a sql table using a DTS. I now want to
go thru that table and either insert (if new) or update (if they
exist) the records into another table within the same DTS. I can do
this easily using a VBScript task, but was wondering if there was a
more efficient/easy way to do this using one or more of the tasks
available within a DTS package. I am using SQL Server 2000.

Thanks in advance!

from a sql perspecetive that is pretty straight forward now that you have
the data in a table

assuming you have a common field or group of fields that are unique, you can
make one pass doing an update where the keys already match and the second
pass doing an insert if they do not.
"Ratman" <jake (AT) attis (DOT) org> wrote