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...r-dts/200805/1

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

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

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

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

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

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

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

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

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:
--
Jay

Message posted via http://www.sqlmonster.com