sql server replication: DTS Bulk Insert Replication Unique Key Conflict -- sql server replication

DTS Bulk Insert Replication Unique Key Conflict

Kia Alford
11/13/2003 9:16:54 AM

sql server replication: Hi,

I have a user who is trying to do manual bulk inserts from an excel file
to a replicated table. The DTS package she creates is failing because
of a unique key indentifier created by the push replication. Is there a
way around this without having to stop replication each time?

Thanks,
Kia

*** Sent via Developersdex http://www.developersdex.com ***

DTS Bulk Insert Replication Unique Key Conflict

Hilary Cotter
11/14/2003 1:06:42 PM

exactly what do you mean by unique key? A rowguid key or
a unique index?

If it is because of the unique index your excel
spreadsheet has some duplicate data in it which should be
resolved.

[quoted text, click to view]

Re: DTS Bulk Insert Replication Unique Key Conflict

Kia Alford
11/14/2003 2:02:32 PM

Thanks Hilary!

It is the rowguid, it's not a key I put on it's a key that was put on by
the replication to tracking the changes on the table for the publication
of the subscription.

I was thinking I could create a job with the agent to stop replication
and then let the user upload with a dts and have the next step of the
job be to start replication again. But I wanted a better way...

Thanks again.

*** Sent via Developersdex http://www.developersdex.com ***

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server replication group.