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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2007-02-15 : 09:22:24
|
| Chris writes "We are trying to import data to a new table with a primary ident key called REFNO which auto escalates by one. There are no other indexes in the new table at present. The ident field is set to populate itself and is ignored in the mapping procedure.The import seems to go through the motions but fails when the last record is read.The error message is :DTS IMPORTTHE TASK REPORTED FAILURE ON EXECUTIONTHE STATEMENT HAS BEEN TERMINATEDCANNOT INSERT THE VALUE NULL INTO COLUMN 'REFNO'COLUMN DOES NOT ALLOW NULLS INSERT FAILS.Obviously the primary key field must be unique and contain no nulls, but as it is autopopulating how can it be null ?Any ideas !!!Chris" |
|
|
|
|
|
DTS Import