HostWeb Forums » Microsoft Databases » microsoft.public.sqlserver.dts » Violation of Primary constraint' cannot insert duplicate key in object
Topic: Violation of Primary constraint' cannot insert duplicate key in object
I continue to get this message though there are no duplicate keys in the
table/s I am transferring into the new table I am creating using DTS. I
created a query to look to duplicate primary keys and did not get any
duplicates after running it. The DTS is a copy and has been modified (another
table has been added to the transfer). The copied DTS package has been
pointed to a test copy of the original database to make sure everything works
properly before moving the modification to production. To make sure I did not
make any changes that the original DTS has I re-directed the original the
test database and recieved the same error. Is there anything else I should be
looking at to correct this problem.
--
Jay
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-dts/200805/1
Replies below ↓
Replies
Re: Violation of Primary constraint' cannot insert duplicate key in object
Hi Jay,
You say "I created a query to look to duplicate primary keys ..." -
but did you run the exact query that DTS is using? If not, try that
and let us know the outcome.
Good luck!
J
Re: Violation of Primary constraint' cannot insert duplicate key in object
Sorry about this late reply but after your response I did go out and run the
query used by the dts and did not get any duplicates (see query below with
modification to look for duplicates)
SELECT evWLlegalintake.event_id
FROM evWLlegalintake
GROUP BY evWLlegalintake.event_id
HAVING (COUNT(*) > 1)
jhofmeyr@googlemail.com wrote:
>Hi Jay,
>
>You say "I created a query to look to duplicate primary keys ..." -
>but did you run the exact query that DTS is using? If not, try that
>and let us know the outcome.
>
>Good luck!
>J
--
Jay
Message posted via http://www.sqlmonster.com