No announcements
Found 1414853 threads
-
2 Votesfilter out the records that are violating constraints
when you have constraints in destination table, if any row violate this constraint the Data Flow return an error and package fails.Answered | 4 Replies | 3628 Views | Created by psingla - Monday, August 23, 2010 11:15 AM | Last reply by Prabhat_IE - Monday, August 23, 2010 2:26 PM
-
0 Votes
updating target with out violating primary and unique constraints or droping constraints
Thanks --CELKO , merge is a better soution , when i use tom's script and run it was working fine for those temp tables , but in my actual database tables am getting the same violation error ...Answered | 3 Replies | 2231 Views | Created by sql393 - Monday, November 21, 2011 2:52 PM | Last reply by sql393 - Monday, November 21, 2011 9:47 PM -
0 Votes
Violation of UNIQUE KEY constraint
Can you post stucture of your dbo.Roles table along with indexes and constraints and code from the application inserting a new role?Answered | 9 Replies | 1588 Views | Created by Rickaty - Wednesday, August 31, 2016 9:21 PM | Last reply by Naomi N - Thursday, September 1, 2016 9:54 AM -
0 Votes
accssing the details of violated foreign key constraints at runtime
It is not designed to validate your data in some post-cleanup phase and show you the rows and columns that violate them.Answered | 3 Replies | 1185 Views | Created by Ganesh Gidde - Tuesday, June 11, 2013 9:46 AM | Last reply by scott_morris-ga - Tuesday, June 11, 2013 12:38 PM -
1 Votes
Unique Constraint Violation
Thus when you try to insert the same value of 'IT10' a second time, the unique constraint is violated and the insert is blocked.Answered | 4 Replies | 1498 Views | Created by Tommy LeFart - Monday, May 13, 2013 5:25 PM | Last reply by Chris Sijtsma - Monday, May 13, 2013 8:07 PM -
1 Votes
Description: "Violation of PRIMARY KEY constraint
It is clearly a Primary Key violation error, which would occur if source data has duplicate value(s) for the destination primary key of the table 'dbo.FACT_CitationDetails'.Answered | 6 Replies | 6969 Views | Created by thinkingeye - Monday, August 13, 2012 2:07 PM | Last reply by thinkingeye - Wednesday, September 12, 2012 2:14 PM -
0 Votes
Handle Violation of Primary Key Constraint in SSIS
I am getting the following error when running an integration services project to insert and Update data from one sql server ...Answered | 4 Replies | 17296 Views | Created by Bhushan W Juare - Friday, November 11, 2011 8:26 AM | Last reply by Eileen Zhao - Wednesday, November 16, 2011 8:54 AM -
0 Votes
Violation of PRIMARY KEY constraint, How is This Possible?
You are trying to insert records into this table that have id(s) already existing in the table.Answered | 2 Replies | 5786 Views | Created by j_c_b_2 - Monday, May 2, 2011 11:48 PM | Last reply by Sali SQL - Tuesday, May 3, 2011 3:33 AM -
1 Votes
insert statement violated because Foreign key constraint
I'll try to figure it out.Answered | 8 Replies | 8443 Views | Created by AjieLeksono - Wednesday, December 1, 2010 7:18 AM | Last reply by AjieLeksono - Wednesday, December 8, 2010 2:55 AM -
1 Votes
Failed to enable constraints.
Hi polachan, According to your description, you are able to return records in dataset preview, but when you run the application the error “Failed to enable ...Answered | 1 Replies | 2378 Views | Created by polachan - Friday, January 1, 2016 6:39 PM | Last reply by Qiuyun Yu - Monday, January 4, 2016 6:17 AM -
2 Votes
Getting violation error even after disabling the constraint
It only applies to CHECK and FOREIGN KEY constraints, and not to UNIQUE or PRIMARY KEY.Answered | 5 Replies | 3441 Views | Created by Murali_CHN - Friday, January 20, 2012 12:27 PM | Last reply by REY - Singh - Monday, January 23, 2012 4:27 PM -
0 Votes
Violation of PRIMARY KEY constraint
SELECT * INTO Attributes_New FROM Production.Product WHERE 1 = 0 2) Drop 'Id' Column and its ...Answered | 6 Replies | 3236 Views | Created by mkerr - Wednesday, November 2, 2011 11:57 AM | Last reply by Stefan Hoffmann - Wednesday, November 2, 2011 12:35 PM -
0 Votes
Violation of PRIMARY KEY constraint on replication
To alleviate the PK violations — you'll want to identify the max identity value used in each publisher and subscribers currently allocated ...Answered | 1 Replies | 5825 Views | Created by Saburo - Thursday, February 16, 2012 8:03 AM | Last reply by Brandon Williams - Monday, February 20, 2012 2:35 AM -
53 Votes
Failed to enable constraints.
One or more rows contain values violating non-null, unique, or foreign-key constraints.Answered | 66 Replies | 259615 Views | Created by Lee Timmins - Monday, July 10, 2006 2:51 PM | Last reply by great_scandinavian - Sunday, December 16, 2012 9:55 AM -
0 Votes
Violation of unique constraint – But there is no duplicate value?
Run the load with out the UNIQUE constraint in place, and then check the contents.Answered | 8 Replies | 1158 Views | Created by Mpumelelo S - Thursday, January 16, 2020 12:31 AM | Last reply by Lily Lii - Monday, January 20, 2020 1:51 AM -
0 Votes
ChangeTracker.DetectChanges() : a referential integrity constraint violation occurred
Calling Detecting change after a Find should not do a difference at any point to violate a constraint.Answered | 4 Replies | 4624 Views | Created by Patrick Desjardins - Saturday, November 15, 2014 5:33 AM | Last reply by Fred Bao - Tuesday, November 25, 2014 8:38 AM -
1 Votes
Filtering out records not working - ARRRGH
OMG, how could i space out LEN; the one single thing I didn't try.Answered | 8 Replies | 1868 Views | Created by Kuj - Thursday, November 29, 2012 6:29 PM | Last reply by TVanover - Thursday, November 29, 2012 8:37 PM -
0 Votes
Msg 2627 Violation of PRIMARY KEY constraint but no dups are in table
Example: declare @T table (c1 int not null PRIMARY KEY); insert into @T(c1) values (1), (1), -- duplicate key (1) (2), ...Answered | 5 Replies | 12636 Views | Created by sqlsingh - Friday, August 3, 2012 2:40 PM | Last reply by sqlsingh - Friday, August 3, 2012 3:19 PM -
0 Votes
how to throw an exception if a dataTable constraint is violated?
Sometimes it catches a constraint violation, most of the time it doesn't.Answered | 6 Replies | 1744 Views | Created by Rich P123 - Thursday, October 1, 2015 5:44 PM | Last reply by Kristin Xie - Wednesday, October 14, 2015 9:57 AM -
2 Votes
violation of primary key constraint
we have an apllicatin dong inserts and we see errors like below violation of primary key constraint a batch of sql statements conyain multiple ...Answered | 9 Replies | 6427 Views | Created by neophytenik - Wednesday, August 4, 2010 6:34 PM | Last reply by Tom Cooper - Thursday, August 5, 2010 5:56 PM - Items 1 to 20 of 1414853 Next ›
No announcements
