Greetings. I have a situation that I would like help with.
I have created a DTS to pull data from one table to
another. To help with my scenario, here is part of my
table structure

Table1 - (USERID, YEAR, FAMILYID, DELETED, (other fields))
PK - USERID, YEAR

Table2 - (USERID, YEAR, FAMILYID, DELETED)
PK - USERID, YEAR

I would like to update Table2 once a day. If FAMILYID or
DELETED has changed for the USERID, YEAR combination I
would like to update the record in Table2. If there is not
a current USERID, YEAR record in Table2, I would like the
record added. How would I do this? I created a DTS
package, but it won't update current records. It wants to
drop them and recreate them and I don't want the record
dropped.

On Mon, 5 Apr 2004 12:35:32 -0700, "Paige" <rmrper99 (AT) comcast (DOT) net>
wrote:

A much simpler method would be to use a view. Since table 2 is
basically a duplicate of the first four fields, why bother updating?