The value violated the integrity constraints for the column

[OLE DB Destination [26]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Unspecified error". [OLE DB Destination [26]] Error: There was an error with input column "Server" (48) on input "OLE DB Destination Input" (39). The column status returned was: "The value violated the integrity constraints for the column.".

Thursday, April 29, 2010

The value violated the integrity constraints for the column

SQL Issue: The value violated the integrity constraints for the column

Solution:

Look at the name of the column for this error/warning.
Go to SSMS and find the table
Allow Null for that Column
Save the table
Rerun the SSIS

The value violated the integrity constraints for the column

Thursday, April 29, 2010

The value violated the integrity constraints for the column

About Me

Blog Archive