Home Forums Data Warehousing Data Transformation Services (DTS) DTS and Primary Keys RE: DTS and Primary Keys
Steve Jones - SSC Editor
SSC Guru
Points: 734459
More actions
April 3, 2017 at 7:16 am
#1936270
If I get the timing, then yes. I don't believe a batch insert "reserves" any numbers, so it's possible.
If you are concerned, I'd do this- dbcc reseed to max + 1010 (allow for some activity between query MAX() and dbcc)- run DTS