The Row Number Transformation calculates a row number for each row, and adds this as a new output column to the data flow. The column number is a sequential number, based on a seed value. Each row receives the next number in the sequence, based on the defined increment value.

Develop seamlessly between Management Studio and Visual Studio SQL Connect is a Visual Studio add-in that makes it easy to keep your database and Visual Studio project in sync.