Version: 1.2.0.7
Size:
566 KB
Requirements:
SQL Server 2005 or higher
SQL Server 2005 or higher
Price:
Free
Free
System:
Windows Vista/XP/2000
Windows Vista/XP/2000
Rating:
4.8
4.8
License:
Freeware
Freeware
serial number generator nero serial number nero 6 serial number photoshop serial number virtual dj serial number sql server vista transformation pack 9
Description - Row Number Transformation
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 SQLIS.com, our free community resource site for SQL Server Integration Services.