I'm a newbie to DTS and I have two questions:

1. How would I go about updating existing records using
DTS? FOr example, I have two data sources, one is being
updated regularly. The other one is just a "copy" which I
am loading records from the first table into periodically.
The problem is the source table gets updates also. I need
to get those updates into the destination table.

2. Is there an issue with updating records if the table
has an Insert trigger on it? I saw a reference in another
post that said "As long as the table does not have an
insert trigger". So I was wondering what this may have
meant.

TIA

OK so you have

1 Source
1 Destination

You have a variety of actions performed on the Source table (UPDATES /
INSERTS)

I personally would put an ON UPDATE TRIGGER and an ON INSERT TRIGGER into
the source table. This would capture the values I wanted and the action
type performed. You can then use the Data Driven Query task to execute the
correct query based on the type of action taken on the Source table.

Hope that makes sense

CREATE TABLE
trigSource
(
SourceID.......................................... .........,
SourceAction CHAR(1) CHECK(SourceAction IN('I','U','D'))
)



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Julie" <anonymous (AT) discussions (DOT) microsoft.com> wrote