2 docs tagged with "rownumber"

Adds a sequential row-number column to a flat-file export by piping an OLE DB source through a Script Component transformation that increments a counter for every row, so downstream business users have a stable line reference when reporting issues with the file.

Loops over every user table in a SQL Server source and emits one extract package per table; each package reads the current max(rownumber) from the destination, runs the source through a Script Component transformation that adds an incrementing 'rownumber' column, and writes it to the destination table.