DTS Package / Import Wizard
Posted on 2004-10-05
I think I am missing something really stupid here, but here goes...
SQL Server 2000
Windows Server 2003
Need to update - append - a huge table in an existing database.
created an Access DB that has a table with desired data.
Try to use the Import Data Wizard in EM and follow steps to transform the data in what appears to be correct.
Error out with:
The Task reported failure on execution.
The statement has been terminated.
Cannot insert the value NULL into column 'ROWID', table 'xxx'; column does not allow nulls. INSERT fails.
My question is how do I get the transformation to 'ignore' the ROWID and automatically update the ROWID with the correct sequential value???
I have missed something, because an import of data using Access itself works fine. SQL 'knows' that rowid is not supposed to be imported and just updates it in the proper order.
What have I missed?