SEQNUM

Description

Returns the next sequential number. The first number returned is the initial value set as a parameter in this function. After that the count is incremented by one and returned.

Syntax

SEQNUM ( initial_value_number )

Parameter	Description
initial_value_number	The starting value for the sequence number.

Remarks

If initial_value_number is not specified, this function returns 1 for the first source row. The initial value is reset every time the DTS file is run.

Examples

This function returns 1 for the first source row and 2 for the second source row:

SEQNUM( )

This function returns 123 for the first source row and 124 for the second source row:

SEQNUM( 123 )