I have a table with some existing data in it. It has an identity column - since I wanted to keep the ID the same as the PK in the table it was migrated from, I inserted into that by allowing identity insert.
I now have a bulk copy that is inserting data into this table. It works fine when I point it to an identical table which is empty, but fails when I try to make it insert into the actual table.
I have set the identity seed to be the max+1 of existing records, so I really can't see why it would fail. Any help would be appreciated. Also, if anyone could help me with how to figure out why my bcp is going wrong in more general terms - the errors file I set up is empty.
I now have a bulk copy that is inserting data into this table. It works fine when I point it to an identical table which is empty, but fails when I try to make it insert into the actual table.
I have set the identity seed to be the max+1 of existing records, so I really can't see why it would fail. Any help would be appreciated. Also, if anyone could help me with how to figure out why my bcp is going wrong in more general terms - the errors file I set up is empty.