Incrementing a column value in SSIS

added by jacobsebastian
4/6/2010 11:45:31 PM

3 Kicks, 87 Views

Many times it is required to insert an incremental value inside a column and we tend to use Identity column to achieve it. But what if we already have an identity column in the same table? To achieve this we write some custom logic to fetch the maximum value and increment the value by one.