Skip to main content

Posts

Showing posts from January, 2013

Error: The value violated the integrity constraints for the column

[OLE DB Destination [730]] Error: There was an error with input column "Email" (689) on input "OLE DB Destination Input" (362). The column status returned was: "The value violated the integrity constraints for the column.". We have created table initially with EMAIL Column as "NOT NULL". While loading Data from Flat File to SQL Server Table, We got this above mentioned error. We looked into few data from Source where we found we had Some "NULL" Values and this is reason we got this Error. We fixed it by changing EMAIL Column at Destination Table like to allow "Null" Values and then populated the records and it worked like charm!!!