Incrementing A User Variable In Data Flow Task

Hello All,

I have a user variable , say max_id, which retrieves the max id from a primary key column of a table.

now in Data Flow Task, I have a Derived Column where I am creating a new column which will have the values max_id + 1 for the first record, then max_id + 2 for the second record of the derived column and so on..

and then I am mapping this derived column with that primary key column of the table, so that the new id's are different than the old ones which are already in the table, so there wont be any primary key violation.

I cannot make that primary key column as an Identity column.

my question is how do I increment this max_id user variable everytime ?

Regards,
Kapadia Shalin P.