You can use lookups for this but this will be slow if you have a large
amount if records that need transferring. I personally would maintain a
list of the rows and their state. I would do this through triggers so that
if a row was inserted I would log this fact and if it was updated I would
log this as well. I would then use the Data Driven Query task to execute
the correct statement at the destination.

--

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


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

key has been violated. What I would like to do is update the row if one
already exists but insert a row if it doesn't. Any suggestions.

What would be nice is the MERGE command. Kinda like that other database
(starts with a big O) has.
It's a really usefull command, it lets you do an Insert / Update in one
command. Or maybe will it be in Yukon ?

Chris.

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

And maybe it won't. In Yukon you do have MERGE JOIN tasks. You will still
have to do the logic AFAIK.

--

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


"Christian Boult" <chrboult (AT) sympatico (DOT) ca> wrote