Home Forums Data Warehousing Integration Services Cannot load into table having identity column - INSERT fails RE: Cannot load into table having identity column - INSERT fails

  • January 11, 2014 at 10:11 pm

    #1679403

    Montana Life (1/11/2014)

    I tried to replicate the issue as you described and did not have the problem using 2012. Keep identity should be unchecked and is by default.

    Yes, iidentity is also unchecked.

    Is a field mapped to the EID column in the Mappings section?

    No, the field is not mapped to EID column as there is no field. From the flat file side it is <ignore>.

    By chance did you select the name of the table then click the new button to the right (doubtful)?

    I am not sure what this is asking.

    Mike

    Mike, thanks for taking a look at this, and lending your mind to my problem, plus testing it in 2012. I hope my install of SQL Server Data Tools aka BIDS 2012, goes well.

    --Quote me