Post reply

Import excel data to a table column having identity property and primary key

  • June 11, 2012 at 4:06 am

    #262742

    Hi,

    I am new to SSIS.

    While importing data from excel sheet to a table having a coloumn(eno) with identity and primary key.

    I have excel structure as

    eno ename eaddr

    xyz dggfdg

    abc sdfddg

    i got error as:

    ' Failure inserting into the read-only column "Empno". '

    Can anyone give solution.

    Thanks in Advance:-)

    - Hemanth

  • June 11, 2012 at 7:24 am

    #1499308

    Either turn on identity_insert or exclude the id field from the excel file and instead use the auto populated identity field in the sql destination table.

  • June 13, 2012 at 5:28 am

    #1500271

    Hey thank you....i got the output.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply