The Sequence Generator transformation is a passive transformation that generates numeric values. Use the Sequence Generator transformation to create unique primary key values, replace missing primary keys, or cycle through a sequential range of numbers.

The Sequence Generator contains pass-through ports and an output port. You connect the NEXTVAL port to the input ports of other transformations. The Integration Service increments the sequence when the mapping runs.

You can create a Sequence Generator transformation based on a new sequence or a sequence data object. A sequence data object is an object that creates and maintains a sequence of values.