Post reply

Primary key constraint error--urgent request

  • October 5, 2005 at 5:33 pm

    #110420

    Hi Everyone

     

    I ran a  DTS task and i am getting the following error

    Violation of primary key constraint  'KPS_PK' cannot insert duplicate key in object 'KPS'

     

    can someone please help me with this

     

    Thanks!

  • October 5, 2005 at 8:06 pm

    #595323

    Your destination table has a primary key.

    Your trying to insert either duplicate rows into the table, or the primary key of one of the rows your trying to insert already exists.

    There is no fix for this.

    You need to check your data, and in your dts, you may need to truncate destination table first.

     

  • October 6, 2005 at 2:50 am

    #595366

    The thing might be that records with the same primary key are already inserted (before, or insert is executed more than once - error?) into this table. Is your table empty?

    Maybe you're doing this all in a transaction block that rollbacks all insert when this violation occurs, so you don't see any records afterall...

    ***

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

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