SSIS Row Number
Generating Row Number in SSIS for each record.
Steps for Generating Row Numbers are:
Step 1: Add Data Flow.
![](/Data_Flow.png)
Step 2: Add Flat File Data Source.
![](/FlatFile.png)
Step 3: Add Script Component.
![](/Add_Scirpt_Component.png)
Step 4: Edit Script Component. Add Output Column.
![](/Script_Component.png)
Step 5: Edit Script
![](/EditScript.png)
![](/Script.png)
Download Project and Sample file
|