I am trying to import an Excel file into SQL Server database using SSIS but I am receiving the error:
The value violated the integrity constraints for the column.
There is only one constraint for the column (NOT NULL), I edited the column to accept Null values still no solution. I also try to load the data by changing the data type to varchar using a data conversion transformation and also changed the destination type to varchar. I have tried these two methods, none has worked.
I need help please.