SSIS Error – The value violated the integrity constraints for the column
Hi, I have a task yo import data from Excel spreadsheet to SQL Server table. I have created SSIS package to to this task. I am getting an error when I run the package "[OLE DB Destination ] Error: There was an error with input column “ColumnName” (578) on input “OLE DB Destination Input” (482). The column status returned was: “The value violated the integrity constraints for the column."
You get this error because one of the columns in your OLEDB data source has NULL values and the corresponding column(s) in the OLEDB destination is set to not allow NULL values. You can fix this by either modifying the destination table to allow NULL values or by setting up a default value for the source columns having NULLS.
Check if the Excel has empty rows at the end,because the empty rows were tried to import as null values.
edit | flag
Gokul A Answered on: Jul 01, 2011 at 1:46AM
Post your Answer
Welcome to Ask Amoeba! This is 100% free and interactive site for sharing professional Questions and Answers, Opensource projects, Interview questions. Learners, beginners, Experts stop and share your knowledge and ideas!