Sequence Generator Transformation
The Sequence Generator transformation is a passive and connected transformation that generates numeric values. Use the Sequence Generator to create unique primary key values, replace missing primary keys, or cycle through a sequential range of numbers.
The Sequence Generator transformation contains pass-through fields and two output fields, NEXTVAL and CURRVAL, that you can connect to one or more downstream transformations. You cannot connect a Sequence Generator to upstream transformations.
The Mapping Configuration task generates a numeric sequence of values each time the mapped fields enter a connected transformation. You set the range of numbers in the Mapping Designer. You can change the initial number in the sequence when you run the task. After the task completes, you can see the last value generated for a Sequence Generator transformation in the Activity Log.