I'm trying to import an Excel 2000 file into a SQL Server 2000 table. The
Excel file has 4 columns. The database table mirrors these columns but has
an Identity field (called ID) which I have as PK to satisfy replication
requirements. Also there is the replication field that defaults to newid().
These 2 fields are the last 2 in the table schema. Here's the error I get
when executing the package...

Error at Destination for Row number 5508...
Cannot insert the value NULL into column 'ID' table.....;column does not
allow nulls. INSERT fails.

There are 5508 rows of data in the sheet plus row 1 is column header.

I realize I can import this into a temp table then just run a SQL query to
insert into the other table, but I'm just curious about the error and would
prefer to not have the temp table.

Thanks - Tom

You may be experiencing this problem

Problems With IDENTITY() and the DataPump task.
(http://www.sqldts.com/default.aspx?293)



"Tom Gaughan" <tgaughan (AT) numail (DOT) org> wrote