SSIS Error – The value violated the integrity constraints for the column

7188
Views
1
Answers

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 [469]] 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."

Can any one help me in resolving this issue?

edit | flag
William Patrick
Asked on: Jul 01, 2011 at 1:43AM

1 Answers

46
32
46

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.

or

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

Search

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!

Browse Categories

Browse Tags