need urgent help

  • I need to load a set of data which does not have a primary unique

    key at source side, and the loading procedure is through DTS whcih

    grabs this data file, truncate the import table then dump the data into

    the import table, then using the stored procedure it inserts, updated the

    main table, can i somehow add the unique primary key at sql side .

    I tried adding the sequence number as primary key in the next run

    the import table is truncated and the new set of sequence numbers

    are generated so that does not worked .

    How can I do that?..Please help

    Thanks in advance

  • dbcc checkidentity will allow you to reset the seed for the identity column.

  • Also, using delete instead of truncate will preserve the last identity value.

    R David Francis

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

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