Second run of dbt snapshot -- error message: Identity insert failed

In my SQL server source I have an Orders table with an OrderID as primary key (auto increment)

When I take a snapshot of the Orders table, it runs fine the first time.

The second run with “dbt snapshot” I get the error Identity Insert failed. My guess is because in the generated snapshot table the Order ID was also assigned auto increment.