Ah bingo - I didn't realise the TRUNCATE would reset the seed - this is perfect and exactly what I need to happen. The reseed is now a redundant...

No problem kind Sir!

Yes, the TRUNCATE is always working - there are always 19972 rows in my table after running the package. The identity was continuing from 19973 (not...

Oh, and 'her' not 'him' 😀

Hi,

Thanks for the super-fast replies!

I have just copied and pasted the parts of the package into a new package, reselected the data connections and it worked - 3 times in...