Bulk Insert Auto Increment Primary key

can you bulk insert into a table that has an auto increment primary key, so you're not passing the key? I keep getting an error. Cannot insert explicit value for identity column in table' when IDENTITY_INSERT is set to OFF.

Hey @nroeder! This definitely should be possible. You don’t need to pass in an id column at all, since it’s set to auto-increment on your db side. What does your query currently look like? What values are you passing in to insert?

Well i can't seem to duplicate the error, so i'm not sure.

Oh okay, that seems good for now :sweat_smile:

Definitely let us know if it pops up again!