August 6, 2013 at 10:16 am
I am trying to import from one table into another with the import/export wizard...
The source table has 17 columns , one of them an identity.
I am using a query to insert into the target table.
I exclude the id column from my query and enable identity insert but get the 'Cannot insert null into id column'.
The select on the source returns 189 rows all of which have a value for the id column...
Not sure what I am doing wrong.
Thanks
August 6, 2013 at 10:20 am
If you enable identity insert in the GUI, then you have to include and map the identity field.
If you have it unchecked, you should exclude the field (set to ignore) in the list of fields to import.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy