Home Forums Programming General BULK INSERT error, any ideas? RE: BULK INSERT error, any ideas?

  • Try adding the following before the insert.

    SET IDENTITY_INSERT [ database. [ owner. ] ] { table } { ON | OFF }

     

    Use the ON parameter and it should ignore you trying to put an identity value in for sure. If you still get an error you need to look at the data itself.