DSXchange

Using NextkeyGen() to create and insert surrogate key in target table . Jobs are in schedule. But due to regular insert surrogate key value exceeding the column limit . So its not able to insert data in table.

What is the process should i use in project to refresh the surrogate key values keeping data consistency and integrity within the tables.

Sounds like you should make your surrogate key columns larger in your tables. How are they defined now?

chulett wrote:Sounds like you should make your surrogate key columns larger in your tables. How are they defined now? ...

Sure , its a process to overcome this issue. But i want a permanant solution like- it refresh all the surrogate key values , again re-generate it from starting

The permanent solution is to increase your column length.

again re-generate it from starting

That won't help you maintaining the integrity among the tables.

First define what you mean by "refreshing", generally rolling over a surrogate and starting to reuse them is not a good idea so I assume you mean something else.

ps. That really should be the permanent solution as well, properly sized key values should never overflow... unless we're talking about gi-nor-mous amounts of records here?