January 6, 2004 at 3:25 pm
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
January 6, 2004 at 6:01 pm
dbcc checkidentity will allow you to reset the seed for the identity column.
January 7, 2004 at 8:49 am
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