I'm new with SSIS. I need to add a new column to a dataset that will sequence number in auto increment. I was asked to find a solution without using script component.
I thought to add a new variable with initial value of 1 and increment his value for each row during runtime, but I don't find a way to change the value of the variable without using scrip component. Is there a way to change the value of the variable during runtime without using script component?
