Missing key violation 
Author Message
 Missing key violation
Hi,
my current DTS-package imports records (from another sql server) also there
should be a key violation. The Destination table has a PK build from 4
fields.
Is there any parameter i missed to (de)activate?

regards
Gerald



Sun, 20 Feb 2005 22:24:30 GMT
 Missing key violation

Are you saying you should be triggering a PK violation through the DTS
package running.?

Check that there *IS* violation data in the source.
Check the PK exists.

You cannot turn off a primary key

BTW make sure the package doesn't drop it prior to execution

--

Allan Mitchell
MCSE, MCDBA
www.SQLDTS.com



Mon, 21 Feb 2005 02:41:49 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. INSERT INTO TABLE KEYED ONLY ON IDENTITY COLUMN RESULTS IN KEY VIOLATION (6.5)

2. Violation of PRIMARY KEY constraint Cannot insert duplicate key in object

3. Paradox Key Violation - changing a keyed field

4. Preventing Key Violation for duplicate keys

5. Reordering of key fields leads to key violations (Pdox 5.0)

6. Reordering of key fields leads to key violations (Pdox 5.0)

7. Access Key Violation in Index aaaaaPk....

8. Violation of PRIMARY KEY constraint ??

9. Violation of primary key on backup

10. Violation of primary key constraint

11. primary key access violation?


 
Powered by phpBB® Forum Software