I have a database surrogate key that increments so rapidly (+5000 every 30 mins). I need my SSIS package to reset this database surrogate key to avoid reaching an upper limit value for that field.
How can I do that using SSIS package?
thanks,
Aref
A quick Google revelas that you can use DBCC CHECKIDENT to do this
http://www.mssqlcity.com/FAQ/Devel/reset_identity_column.htm
You can issue the command using the Execute SQL Task.
-Jamie
No comments:
Post a Comment