Row Number Transformation

License: Freeware
Downloads: 1
Op. System: Windows Vista/XP/2000
Last updated: 2008-08-27
File size: 566 KB
Publisher: Konesans Ltd
Related software:

Publisher description for Row Number Transformation

Row Number Transformation program icon

Row Number Transformation calculates a row number for each row. It offers ROW_NUMBER or IDENTITY like behavior, or surrogate key generation within the pipeline. The new row number and is added as a new output column to the data flow. The column number is a sequential number, based on a seed value as set by property or expression. The increment value can also be set similarly via the property or an expression. Each row receives the next number in the sequence, based on the defined increment value.The final row number can be stored in a variable for later Analysis, and can be used as part of a process to validate the integrity of the data movement.The Row Number transform has a variety of uses, such as generating surrogate keys, or as the basis for a data partitioning scheme when combined with the Conditional Split transformation.The Row Number Transformation is available free of charge from, our free community resource site for SQL Server Integration Services.

Add your review

User reviews