Mark Forums Read

Violation of Primary constraint' cannot insert duplicate key in object

Go Back

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Reply

Page 2 of 2

2

#11

Old

Jay via SQLMonster.com

Posts: n/a

Re: Violation of Primary constraint' cannot insert duplicate key inobject - 06-06-2008 , 11:33 AM

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 (AT) googlemail (DOT) com wrote:

Quote:

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

Reply With Quote

#12

Old

Jay via SQLMonster.com

Posts: n/a

Re: Violation of Primary constraint' cannot insert duplicate key inobject - 06-06-2008 , 11:33 AM

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 (AT) googlemail (DOT) com wrote:

Quote:

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

Reply With Quote

#13

Old

Jay via SQLMonster.com

Posts: n/a

Re: Violation of Primary constraint' cannot insert duplicate key inobject - 06-06-2008 , 11:33 AM

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 (AT) googlemail (DOT) com wrote:

Quote:

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

Reply With Quote

#14

Old

Jay via SQLMonster.com

Posts: n/a

Re: Violation of Primary constraint' cannot insert duplicate key inobject - 06-06-2008 , 11:33 AM

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 (AT) googlemail (DOT) com wrote:

Quote:

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

Reply With Quote

#15

Old

Jay via SQLMonster.com

Posts: n/a

Re: Violation of Primary constraint' cannot insert duplicate key inobject - 06-06-2008 , 11:33 AM

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 (AT) googlemail (DOT) com wrote:

Quote:

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

Reply With Quote

#16

Old

Jay via SQLMonster.com

Posts: n/a

Re: Violation of Primary constraint' cannot insert duplicate key inobject - 06-06-2008 , 11:33 AM

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 (AT) googlemail (DOT) com wrote:

Quote:

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

Reply With Quote

#17

Old

Jay via SQLMonster.com

Posts: n/a

Re: Violation of Primary constraint' cannot insert duplicate key inobject - 06-06-2008 , 11:33 AM

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 (AT) googlemail (DOT) com wrote:

Quote:

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

Reply With Quote

Reply

Page 2 of 2

2

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.