March 5, 2022 admin Articles Generating Row Number in SSIS for each record. Steps for Generating Row Numbers are: Step 1: Add Data Flow. Step 2: Add Flat File Data Source. Step 4: Edit Script Component. Add Output Column. Step 5: Edit Script Tags: Business IntelligenceGenerateROW NUMBER