Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
lanadaf
Starting Member
1 Post |
 Posted - 2010-08-12 : 14:06:52
|
| I have looked at multiple threads discussing this same issue but dont see the integrity constraint error I am getting. I need to store numbers with leading zeros ie000100489941I am storing these as nchar(4) to preserve the zeros. When importing either 0001 or 0048 it works fine. When importing 9941 it works fine. But when I try to import both 0001 and 9941 it gives me the error: The column status returned was: "The value violated the integrity constraints for the column."It also told me that the number could not be greater than 255.I have tried importing as .txt, .csv and .xls and keep getting the errors. I tried varchar(4) but same errors. Any ideas? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-12 : 14:25:30
|
| check the metadata of SSIS and check what datatype it interprets the field to be------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Data Type for Numbers w/ Trailing Zeros